home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Night Owl 6
/
Night Owl's Shareware - PDSI-006 - Night Owl Corp (1990).iso
/
050a
/
dayo1_32.zip
/
DAYOMEM.DOC
next >
Wrap
Text File
|
1991-03-17
|
360KB
|
4,451 lines
╔════════════════════════════════════════════════════════════════════════════╗
║ ║
║ ║
║ ║
║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║
║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║
║ ║
║ ║
║ ║
║ ║
║ ██▄█▄██░ █████░ ██▄█▄██░ ██▄███░ ████░ ██▄███░ █████░ ██░ ██░ ████░ ██▄███░║
║ ███████░ ██░ ███████░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░║
║ ███████░ ██░ ███████░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░║
║ ██░█░██░ ████░ ██░█░██░ ██████░ ████░ ██████░ █████░ ██████░ ██░ ██▀███░║
║ ██░█░██░ ██░ ██░█░██░ ██░ ██░ ██░ ██░██░ █░ ██░ ██░ ██░ ██░ ║
║ ██░█░██░ ██░ ██░█░██░ ██░ ██░ ██░ ██░██░ █░ ██░ ██░ ██░ ██░ ║
║ ██░ ██░ █████░ ██░ ██░ ██▀███░ ████░ ██░▀██░ █████░ ██░ ██░ ████░ ██░ ║
║ ║
║ ║
║ ║
║ ║
║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ║
║ ║
║ ║
║ ║
║ ██████ ▀███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ S H N ║
║ ▀ ██ ▀ ████ ▀▀▀▀▀███████████████████████████▌ O A E ║
║ ██ ██ ▄███▄ ▀████▀▀ ▀████████████ F R T ║
║ ██ ██ ██ ▀▀ ███████████ T D W ║
║ ██ ▄ ██ ▀███▄ Specializing In ▐█████████▌ W W O ║
║ ▀███▀ ██ MicroComputer & Network ██████████ A A R ║
║ ▀███▀ Solutions & █████*████▌ R R K ║
║ Applications ▐███████████ E E S ║
║ ▀██ █ ▀█▄███▄ ┌─┐ ┌─┐ ███████████▌ ║
║ ██ █▀█ ██ ██ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ Custom: ║
║ ██ ▄█ █▄ █████ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ Programs ║
║ ██ ██▄██ ██ ██ ▐▀▌ └───╜ ▐▀▌ ███▄▄███ Reports ║
║ ████ ▄█ █▄ █▀███▀ █████ ▐▀▌ █████ ▀█████▌ Routines ║
║ █████ ▀▀▀█ Forms ║
║ P.O. Box 585366 █ ║
║ Orlando, Florida 32858-5366 (407) 291-3960 ▄▄▄▄▀ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Membership, TJS LAB
"Try before you buy..."
┌─────────┐
┌─────┴───┐ │ (tm)
──│ │o │──────────────────
│ ┌─────┴╨──┐ │ Association of
│ │ │─┘ Shareware
└───│ o │ Professionals
──────│ ║ │────────────────────
└────╨────┘ MEMBER
This program is produced by a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware principle
works for you. If you are unable to resolve a shareware-related problem with
an ASP member by contacting the member directly, ASP may be able to help.
The ASP Ombudsman can help you resolve a dispute or problem with an ASP
member, but does not provide technical support for members' products. Please
write to the ASP Ombudsman at 545 Grover Road, Muskegon, MI 49442-9427 or
send a Compuserve message via easyplex to ASP Ombudsman 70007,3536
■ SOFTWARE SUPPORT POLICY
1. TJS LAB does not support users of unregistered DAYO products with the
exception of installation questions.
2. Support (included with registration) remains in effect for 1 year after
date of registration or upgrade.
3. Support is available through the following methods:
- Phone/Voice Mail: (407) 291-3960/6987
- U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366
- Compuserve Easyplex: 76367,1401
4. Any errors ("bugs or features') in the program will be corrected and
the 'fix' sent promptly (via modem if possible).
DAYO Membership, TJS LAB
Table of Contents
Page Subject
──── ───────────────────────────────────────
1...................INTRODUCTION
2...................COPYRIGHT/LICENSE
2...................DISCLAIMER
2...................REQUIREMENTS ***
2...................SETUP
3...................MAIN MENU
3...................PASSWORD/NAME
4...................BROWSE MEMBERS
5...................FULL SCREEN EDIT - F2
5...................FIND MEMBER - F5,F6,F7,F8,F9,F10
6...................HELP - F1
6...................MEMBER NOTES - F3
6...................IMPORT FILE
7...................VIEW PAYMENTS - F4
7...................MAKE PAYMENT - CTRL F1
8...................PAYMENT EXAMPLE
9...................PRINT/REPRINT PAYMENT - ALT P
9...................PRINT STATEMENT - ALT S
9...................STATEMENT EXAMPLE
10...................PRINT STANDARD LABEL - ALT L
10...................CREATE INVOICE - ALT B
11...................INVOICE EXAMPLE
12...................CREATE CUSTOMER RECORD - ALT M
12...................VIEW PAYMENT CODES - ALT F1
13...................REPORTS
13...................REPORTS/ROUTINES LIST
14...................PRINTER SETUP
14...................PRINTER DRIVER OPTIONS
15...................CHANGE DEFAULT PRINTER
16...................FULL SCREEN EDIT - F2
16...................PRINTER DRIVER DATABASE FIELD DEFINITIONS
17...................MEMBERS LIST #1
19...................PROGRESS GRAPH
19...................MEMBER LIST #1 EXAMPLE
20...................MEMBERS LIST #2
21...................MEMBERS EXPANDED #1
22...................MEMBERS EXPANDED #2
23...................MEMBERS EXPANDED #3
24...................AGEING
25...................NOTES (MEMBER)
26...................DUMP (COMPLETE DATA)
27...................MEMBER DUMP EXAMPLE - PART 1
27...................MEMBER DUMP EXAMPLE - PART 2
28...................MEMBER DUMP EXAMPLE - PART 3
28...................MEMBER DUMP EXAMPLE - PART 4
29...................RECEIPTS STATEMENTS
DAYO Membership, TJS LAB
Table of Contents
Page Subject
──── ───────────────────────────────────────
30...................FOLDER LABELS
31...................PROGRESS GRAPH FOR LABELS
31...................LABELS (STANDARD)
32...................BIG LABELS
34...................BIG LABEL CONFIGURATION
35...................PAYMENTS
36...................PAYMENT REPORT EXAMPLE
37...................FORM LETTERS
37...................CREATE NEW FORM LETTER
38...................EDIT/MODIFY EXISTING FORM LETTER
39...................FORM LETTER EDITOR
39...................IMPORT TEXT FILE INTO FORM LETTER - F2
40...................VIEW FIELDS (VALID FORM LETTER CODES) - F3
40...................BROWSE INVOICES
41...................FULL SCREEN EDIT - F2
41...................DISPLAY MEMBER INFORMATION - F3
42...................INVOICES
43...................CONFIG STATUS
43...................CONFIG STATUS REPORT EXAMPLE
45...................VIEW REPORTS ON SCREEN
46...................CONFIGURATION
46...................LIST OF CONFIGURATION OPTIONS
47...................ASSOCIATION NAME
47...................ASSOCIATION ADDRESS
47...................ASSOCIATION PHONE
47...................LAST MEMBER NUMBER
48...................NEXT DUE DATE
48...................DEFAULT TYPE
48...................DEFAULT GROUP
49...................DEFAULT CLASS CODE
49...................CUSTOMER LOCATION
49...................CURRENT DIRECTORY
49...................FORM LETTER LOCATION
50...................PAYMENT PORT
50...................PAYMENT COPIES
50...................AUTO PRINT PAYMENTS
50...................BALANCE ON RECEIPT
50...................DEFAULT PAYMENT COMMENT
51...................STATEMENT PORT
51...................STATEMENT COPIES
51...................DEFAULT STATEMENT COMMENT
51...................INVOICE PORT
51...................INVOICE COPIES
52...................AUTO PRINT INVOICE
52...................DEFAULT INVOICE COMMENT
52...................LABELS PORT
DAYO Membership, TJS LAB
Table of Contents
Page Subject
──── ───────────────────────────────────────
52...................AUTO PRINT LABELS
52...................REPORT PRINTER TYPE
53...................REPORT PRINTER PORT
53...................VISUAL INDEXING
53...................VISUAL INDEXING
53...................PAYMENT TITLE
54...................INVOICE TITLE
54...................COLOR
54...................HIGH INTENSITY
55...................MISCELLANEOUS ROUTINES
55...................LIST OF MISC ROUTINES:
56...................APPEND FROM
58...................BROWSE DATABASES
60...................COPY (.DBF) TO
62...................CREATE DATABASE
64...................DELETE RECORDS
65...................ERASE FILE
66...................INDEX A DATABASE
67...................LIST FIELDS
70...................MODIFY DATABASE
71...................PACK DATABASE
72...................RECALL RECORDS
72...................RETURN TO MENU
72...................RUN (DOS COMMAND)
73...................SIMPLE EDITOR
74...................SORT DATABASE
75...................TYPE (PRINT) FILE
76...................ZAP DATABASE
78...................HELP SCREENS
79...................EXPANDED HELP
80...................USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
81...................VIEW DOCUMENTATION ONSCREEN
82...................DATABASE STRUCTURE
84...................DATA DICTIONARY
85...................DAYO POS MAINTENANCE & QUIRKS
87...................TJS 'Computer' LAB
DAYO Membership, TJS LAB Page: 1
■ INTRODUCTION
DAYO Membership is an application designed to track membership for an
association or organization. The ability to maintain records for donations,
dues, payments and/or invoices has also been incorporated into the package.
Use DAYO Membership to record member information and optionally, maintain a
simple accounting system for dues and/or donations.
Many reports and reporting routines are included in this package, ie:
Members List #1, Members List #2, Members Expanded #1, Members Expanded #2,
Members Expanded #3, Ageing, Notes (Member), Dump (Complete Data),
Receipts Statements, Folder Labels, Labels (Standard), Big Labels,
Payments, Form Letters, Browse Invoices, Invoices, Config Status, View
Reports On Screen, and Printer Setup.
Over 33 configuration options exist to further define how you wish to
operate, ie: Association Name, Association Address, Association Phone, Last
Member Number, Next Due Date, Default Type, Default Group, Default Class
Code, Customer Location, Current Directory, Form Letter Location, Payment
Port, Payment Copies, Auto Print Payments, Balance On Receipt, Default Pay
Comment, Statement Port, Statement Copies, Default Statement Comment, Invoice
Port, Invoice Copies, Auto Print Invoice, Default Invoice Comment, Labels
Port, Auto Print Labels, Report Printer Type, Report Printer Port, Visual
Indexing, Auto Daily Indexing, Payment Title, Invoice Title, Color Screens,
and High Intensity Color.
A simple database management system is also included that increases your
capabilities. With these routines, you can add data fields to the existing
databases, or even create new databases to record information specific to
your organization.
Just some of the other DAYO products:
DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
DAYO POS Point of Sale, Billing & Invoicing
DAYO Quotes Sales Quoting System
DAYO Price Books Special pricing for your customers as well as a wide
range of product catalogs/reports
DAYO AR Accounts Receivable
DAYO AP Accounts Payable
DAYO BO Back Orders
DAYO GL General Ledger
DAYO Menu Menu
DAYO Passwords Password protect your DAYO modules
DAYO Smart Reports A variety of reports pertaining to the above modules
DAYOX Network/LAN Index Maintenance Utility
DAYO Membership, TJS LAB Page: 2
■ COPYRIGHT/LICENSE
This manual and software is copyrighted with all rights reserved by
TJS LAB. No copying of this manual or software is authorized without
the prior written consent of TJS LAB. An exception to this rule is the
making of backup copies of registered software disks. No RESALE of any part
of the source codes is authorized without the prior written consent of
TJS LAB. TJS LAB retains all rights to DAYO Membership software,
documentation, and source codes.
Read the Order Form (last page) for more information on Source Codes.
Authorization to distribute the Shareware Version (unregistered) is
granted.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform as
expected, however, this software is licensed "AS IS".
TJS LAB will not be liable for any damage done to your data, hardware,
and/or software systems as a result of using DAYO Membership.
■ REQUIREMENTS ***
IBM or Compatible CPU
640K memory
* DOS 3.3 or above
Hard Disk
■ SETUP
To setup DAYO Membership, copy the contents of the DAYO Membership
floppy disks into a directory on your hard disk (ie: \DAYOMEM). If this is
the Shareware Version, UnZip/UnArc the files. When running DAYOMEM for the
first time, it will create all the database, index, and configuration files
it requires for operation. If other DAYO modules are being used, be sure to
enter the location of these databases into the DAYO Membership configuration.
Type and enter 'DAYOM' at the DOS prompt to run the program (ie: C:\DAYOM ).
DAYO Membership, TJS LAB Page: 3
■ MAIN MENU
After a few moments and possibly a reindex, the main menu will appear:
DAYO Membership Version 1.1 TJS LAB
Copyright (C) 1991 All Rights Reserved
╓────────────────────╖ ┌────▌March 1991▐────┐
║ 1 MEMBER ║ │S M T W T F S │
╟────────────────────╢ █▄███▄ ▄███▄ ██░ ██░ ▄████▄ ├────────────────────┤
║ 2 REPORTS ║ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ │ 1 2│
╟────────────────────╢ ██░ ██░ ██░██░ ▀█████░ ██░ ██░ │ 3 4 5 6 7 8 9│
║ 3 CONFIGURATION ║ ██░ ██░ ███▀███░ ▀██▀ ██░ ██░ │10 11 12 13 14 15 16│
╟────────────────────╢ ██░ ██░ ██░ ██░ ██░ ██░ ██░ │17 18 19 20 21 22 23│
║ 4 MISC ROUTINES ║ █▀███▀ ██░ ██░ ██░ ▀████▀ │24 25 26 27 28 29 30│
╟────────────────────╢ │31 │
║ 5 EXIT ║ └────────────────────┘
╚════════════════════╝ ╔════════════════════════════╗
║ Member Records: 173 ║
╚════════════════════════════╝
██▄██▄██░ █████░ ██▄██▄██░ ██▄███░ ████░ ██▄███░ ██████░ ██░ ██░ ████░ ██▄███░
████████░ ██░ ████████░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░██░██░ ████░ ██░██░██░ ██████░ ████░ ██████░ ██████░ ██████░ ██░ ██▀███░
██░██░██░ ██░ ██░██░██░ ██░ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ █████░ ██░ ██░ ██▀███░ ████░ ██░▀██░ ██████░ ██░ ██░ ████░ ██░
Maintain, Create, Edit & View Members
■ PASSWORD/NAME
From the main menu, after entering your name or password, you can enter
any of the modules.
From the main menu, after entering your name or password, you can enter
any of the modules.
┌────────────────────────────────────────────────────────────────────────────┐
│┌──────────────────────────────────────────────────────────────────────────┐│
││ Enter Your Name: TOM JOHNSON ││
│└──────────────────────────────────────────────────────────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 4
■ BROWSE MEMBERS
The first option on the main menu is the browse of the members database
(MEMBERS.DBF). This is the 'all important' maintenance routine for DAYO
Membership. From this browse, you can edit the members data (Press F2 or the
Enter/Return key), seek a specific member based on multiple indexes (6 of
them), view the user manual on screen (Press F1), Edit and/or view a members
notes (Press F3), view a members record of payments (Press F4), record/make
a payment for a member (Press Ctrl F1), print or reprint a payment (Press
Alt P), print out a statement of previous payments (Press Alt S), print a
standard mailing label (Press Alt L), create an invoice for dues (Press
Alt B), create a DAYO customer record (in database CUSTOMER.DBF) for use
with the other DAYO modules (Press Alt M), and view the payment codes (Press
Alt F1).
DAYO Membership Version 1.1 TJS LAB
╔══════════════════▌ BROWSE MEMBERS DATABASE: MEMBERS.DBF ▐══════════════════╗
║ Member: 100006-SM Name: Scott Mahan (Butthead) ║
║ Phone #1: (800) 555-1234 P.O. Box 5555 Date: 03/04/89║
║ Phone #2: Suite #1001 Class: XXX ║
║ Group: GROUP A3 Method: 3 Anycity, FL 55555-5555 Type: Regular║
║ Last: 02/23/93 Next: 12/11/90 Dues: 10.00 Balance: 954.00║
║ Comment: Check behind him for cigarette butts <ACTIVE> ║
╠════════════════════════════════════════════════════════════════════════════╣
║ MEMBER NAME FIRSTNAME ║
║───────────────────╥───────────────────────────────╥────────────────────────║
║ 10002-AW ║ Andrew Watcher ║ Drew ║
║ 10003-GM ║ George Moonilal ║ George ║
║ 10004-AAA ║ Andrew A. Altizer ║ Andy ║
║ 10005-BD ║ Brenda Davidson ║ Brenda ║
║ 10006-SM ║ Scott Mahan ║ Butthead ║
║ 10007-SR ║ Steve Rhodes ║ Steve ║
║ 10008-MR ║ Marv Ritter ║ Marv ║
║ 10009-LS ║ Lee Siddons ║ Lee ║
╠════════════════════════════════════════════════════════════════════════════╣
║ Esc(Exit) F1(Help) F2(Edit) F3(Notes) F4(View Paymemts) Ctrl F1(Payment)║
║ Alt L(Lbl) Alt P(Pmnt) Alt S(Stmt) Alt B(Bill) Alt M(Move) Alt F1(Codes)║
║ Find: F5(Member) F6(Name) F7(Firstname) F8(Phone) F9(Zipcode) F10(Group)║
╚════════════════════════════════════════════════════════════════════════════╝
9/173
DAYO Membership, TJS LAB Page: 5
■ FULL SCREEN EDIT - F2
Press F2 to edit all fields (up to the first 42 of them), on the screen
at once:
╔════════════════════════════▌ FULL SCREEN EDIT ▐════════════════════════════╗
║ MEMBER: 10034-TC COMMENT: Lives at Rosemont ║
║ NAME: Tracy Cromer PMETHOD: 3 ║
║ FIRSTNAME: Tracy ACTIVE: T ║
║ ADDRESS1: 1685 Lincoln Drive ║
║ ADDRESS2: ║
║ CITY: Pomeroy ║
║ STATE: OH ║
║ ZIP: 55555-5555 ║
║ PHONE1: (800) 555-1234 ║
║ PHONE2: ║
║ DATE: 03/04/89 ║
║ LASTDATE: 02/23/93 ║
║ NEXTDATE: 12/11/90 ║
║ BALANCE: 960.00 ║
║ DUES: 10.00 ║
║ PAYHIST: 40.00 ║
║ GROUP: GROUP A3 ║
║ TYPE: Regular ║
║ CLASS: XXX ║
║ FAX: ║
║ CUSTOMER: 30012 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (ABORT & Exit) F1 (Help) PgUp/PgDn (SAVE & Exit) Alt F1 (Show Codes)
■ FIND MEMBER - F5,F6,F7,F8,F9,F10
There are 6 indexes to search for members on:
F5 - Member
F6 - Name
F7 - Firstname
F8 - Right 4 digits of Phone #1
F9 - Zipcode
F10 - Group
DAYO Membership, TJS LAB Page: 6
■ HELP - F1
Press F1 at any time during the program to bring up the Help routine.
The DAYO Membership Help routine consists of a few screens to display the
editor and browse special keys, a user imputted help file, and the viewing
of the user manual on screen.
■ MEMBER NOTES - F3
Use this routine to record special notes about a member. Up to 16,000
bytes of data can be recorded (about 18 normal pages). *** Be sure to
presss Ctrl W to SAVE any changes!!!
╔═══════════════════▌ BROWSE MEMBERS DATABASE: MEMBERS.DBF ▐═════════════════╗
║ Member: 10034-TC Name: Tracy Cromer (Tracy) ║
║ Phone #1: (800) 555-1234 1685 Lincoln Drive Date: 03/04/89║
║ Phone #2: Pomeroy, OH 55555-5555 Class: XXX ║
║ Group: GROUP A3 Method: 3 Anycity, FL 55555-5555 Type: Regular ║
║ Last: 02/23/93 Next: 12/11/90 Dues: 10.00 Balance: 960.00 ║
║ Comment: Lives at Rosemont <ACTIVE> ║
╠════════════════════════════▌ EDIT MEMBER NOTES ▐═══════════════════════════╣
║ Tracy lives with Sally in the 3rd building belonging to Al Rosemont. ║
║ Tracy's special talents include: Tennis, organizing the annual bake off. ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╠════════════════════════════════════════════════════════════════════════════╣
║ Esc (ABORT & Exit) Ctrl W (SAVE & Exit) F1 (Help) F2 (Import) ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
<INSERT ON> 19/0
■ IMPORT FILE
Press F2 to import an existing text file into this members notes:
┌────────────────────────────────────────────────────────────────────────────┐
│ This routine will merge a text file with your current file/memo/mail. │
│ Enter FILE NAME: TEMP.TXT │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 7
■ VIEW PAYMENTS - F4
Press F4 to view (browse) all payments (if any) for a selected member:
╔══════════════════▌ BROWSE MEMBERS DATABASE: MEMBERS.DBF ▐══════════════════╗
║ Member: 10034-TC Name: Tracy Cromer (Tracy) ║
║ Phone #1: (800) 555-1234 1685 Lincoln Drive Date: 03/04/89║
║ Phone #2: Pomeroy, OH 55555-5555 Class: XXX ║
║ Group: GROUP A3 Method: 3 Anycity, FL 55555-5555 Type: Regular ║
║ Last: 02/23/93 Next: 12/11/90 Dues: 10.00 Balance: 960.00 ║
║ Comment: Lives at Rosemont <ACTIVE> ║
╠══════════════════════════▌ VIEW/BROWSE PAYMENTS ▐══════════════════════════╣
║ PAYMENT MEMBER AMOUNT DATE TYPE CLASS ║
║────────────╥──────────────╥────────────╥──────────╥──────────╥─────────────║
║ 9 ║ 100037-TH ║ 10.00 ║ 03/05/91 ║ Regular ║ XXX ║
║ 10 ║ 100038-DA ║ 10.00 ║ 03/05/91 ║ Regular ║ XXX ║
║ 11 ║ 100039-AD ║ 10.00 ║ 03/05/91 ║ Regular ║ XXX ║
║ 12 ║ 100040-HJ ║ 10.00 ║ 03/05/91 ║ Regular ║ 1 ║
║ 13 ║ 100041-FF ║ 10.00 ║ 03/05/91 ║ Regular ║ XXX ║
║ 14 ║ 100042-GF ║ 10.00 ║ 03/05/91 ║ Regular ║ XXX ║
║ 15 ║ 100043-DJ ║ 5.00 ║ 03/05/91 ║ Regular ║ ZZZ ║
║ 16 ║ 100044-YH ║ 10.00 ║ 03/05/91 ║ Regular ║ XXX ║
╠════════════════════════════════════════════════════════════════════════════╣
║ Esc (Exit) F1 (Help) Alt F1 (Show Payment Codes) ║
║ ║
║ Find: F5 (Payment) F6 (Member) ║
╚════════════════════════════════════════════════════════════════════════════╝
■ MAKE PAYMENT - CTRL F1
╔══════════════════▌ BROWSE MEMBERS DATABASE: MEMBERS.DBF ▐══════════════════╗
║ Member: 10034-TC Name: Tracy Cromer (Tracy) ║
║ Phone #1: (800) 555-1234 1685 Lincoln Drive Date: 03/04/89║
║ Phone #2: Pomeroy, OH 55555-5555 Class: XXX ║
║ Group: GROUP A3 Method: 3 Anycity, FL 55555-5555 Type: Regular ║
║ Last: 02/23/93 Next: 12/11/90 Dues: 10.00 Balance: 960.00 ║
║ Comment: Lives at Rosemont <ACTIVE> ║
╠════════════════════════════════════════════════════════════════════════════╣
║ ║
║ ║
║ Enter Payment Amount: 10.00 ║
║ ║
║ Check Number: # 19292 ║
║ ║
║ Type: Regular ║
║ Class: XXX ║
║ Group: GROUP A3 ║
║ ║
╠════════════════════════════════════════════════════════════════════════════╣
║ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Membership, TJS LAB Page: 8
■ PAYMENT EXAMPLE
PAYMENT RECEIPT
Your Organization Date: 03/14/91
Attn: Memberships Time: 20:50:43
P.O. Box 5555
Anycity, FL 555555-5555
Receipt #: 41 800-555-5555
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Donation Received From: (100037-TC)
Tracy Cromer (800) 555-1234
1685 Lincoln Drive
Pomeroy, OH 55555-5555
Group: GROUP A3 Pay Method: 3
Class: XXX Status: Active
Type: Regular Initial Date: 03/04/89
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Amount Comments Date Balance
---------- ------------------------------ -------- ----------
10.00 Check #8383, NCNB 10/31/90 960.00
Thank You For This Payment!
__________________________
DAYO Membership, TJS LAB Page: 9
■ PRINT/REPRINT PAYMENT - ALT P
Press Alt P to print (reprint) the last payment created for the currently
highlighted member.
■ PRINT STATEMENT - ALT S
A Statement is a simple printout of all payments made within a specified
date range.
■ STATEMENT EXAMPLE
STATEMENT
Period: 03/06/90 to 05/06/91
Your Organization Date: 03/14/91
Attn: Memberships Time: 20:51:13
P.O. Box 5555
Anycity, FL 555555-5555 Page: 1
800-555-5555
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Payments Received From: (10037-TC)
Tracy Cromer (800) 555-1234
1685 Lincoln Drive
Pomeroy, OH 55555-5555
Group: GROUP A3 Pay Method: 3
Class: XXX Status: Active
Type: Regular Initial Date: 03/04/89
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Amount Description Date
---------- ------------------------------ --------
10.00 Check #1922, Aug 90 08/05/90
10.00 Check #2002, Sep 90 09/11/90
10.00 Check #2103, Oct 90 10/02/90
10.00 Check #2384, Sep 90 10/31/90
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
40.00 <- Total Payments This Period ***
Current Balance (03/14/91) -> 960.00
Thank You For Letting Me Give You This Statement!
__________________________
DAYO Membership, TJS LAB Page: 10
■ PRINT STANDARD LABEL - ALT L
Press Alt L to print a standard mailing label (3.5" by 15/16") for the
currently highlighted member.
│■└──────────────────────────────────┘■│
│■┌──────────────────────────────────┐■│
│■│ Andy Altizer (Cpt P.) │■│
│■│ 145 East Langdon St │■│
│■│ Suite 23 │■│
│■│ San Fransisco, CA 39393 │■│
│■└──────────────────────────────────┘■│
│■┌──────────────────────────────────┐■│
■ CREATE INVOICE - ALT B
╔═════════════════════════════▌ CREATE INVOICE ▐═════════════════════════════╗
║ ║
║ Tracy Cromer ║
║ Last Payment: 02/23/93 (Tracy) ║
║ Next Payment Due: 03/01/92 1685 Lincoln Drive ║
║ Dues: 10.00 Pomeroy, OH 55555-5555 ║
║ Payment Method: 3 ║
║ Group/Type/Class: GROUP A3/Regular/XXX ║
║ ║
║ Enter the following information to appear on the bill: ║
║ ╔═══════════════════════════════════════════╗ ║
║ ║ AMOUNT DESCRIPTION ║ ║
║ ║ 10.00 REGULAR DUES ║ ║
║ ╚═══════════════════════════════════════════╝ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Membership, TJS LAB Page: 11
■ INVOICE EXAMPLE
INVOICE Invoice #: 6
Your Organization Date: 03/14/91
Attn: Memberships Time: 20:51:38
P.O. Box 5555
Anycity, FL 555555-5555
800-555-5555
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Bill To: (454)
Tracy Cromer (800) 555-1234
1685 Lincoln Drive
Pomeroy, OH 55555-5555
Group: GROUP A3 Pay Method: 3
Class: XXX Status: Active
Type: Regular Initial Date: 03/04/89
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Amount Description Date Due Balance
---------- ------------------------------ -------- ----------
10.00 REGULAR DUES 03/01/92 954.00
Amount Remitted: ______________
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Thank You For This Invoice!
__________________________
DAYO Membership, TJS LAB Page: 12
■ CREATE CUSTOMER RECORD - ALT M
If you are using other DAYO modules, and wish to make a customer
record from data in a member's record, then press Alt M.
■ VIEW PAYMENT CODES - ALT F1
If in doubt about what the payment codes are, just press Alt F1:
╔═══════════════════════════════════════════════════════════════╗
║ DAYO Membership Payment (Dues) Codes ║
║Pay ║
║Code Description ║
║──── ────────────────────────────────────────────────────────║
║ 0 On Call... (Due Dates Not Used!) ║
║ 1 Each Month at a Specified Day (15) ║
║ 2 Every 2 Months at a Specified Day (1) ║
║ 3 Every 3 Months (Quarterly) at a Specified Day (1) ║
║ 4 Every 6 Months (Semi-annually) at a Specified Day (1) ║
║ 5 Every Year (Annually) at a Specified Day (31) ║
║ 6 Every 60 Number of Days ║
║ 7 Every 90 Number of Days ║
║ 8 Every 90 Number of Days ║
║ ║
╚═══════════════════════════════════════════════════════════════╝
DAYO Membership, TJS LAB Page: 13
■ REPORTS
This menu option contains many reports and routines that aide in
reporting your data. All reports, labels and form letters can be directed to
a printer or file. Conditional printing options include specific Group, Type,
Class, sometimes a Date Range, and sometimes specific member numbers.
Multiple index options are available when possible. Write the report to a
disk file (using the default file names or any of your choice), to save on
paper, and increase your 'online' usage of your computers (Save those
trees!).
DAYO Membership Version 1.1 TJS LAB REPORTS
╔═══════════════════════╗ights Reserved
║DAYO MEMBERSHIP REPORTS║ ┌────▌March 1991▐────┐
╟───────────────────────╢ │S M T W T F S │
║ Printer Setup ║█▄███▄ ▄███▄ ██░ ██░ ▄████▄ ├────────────────────┤
║ Members List #1 ║██░ ██░ ██░██░ ██░ ██░ ██░ ██░│ 1 2│
║ Members List #2 ║██░ ██░ ██░██░ ▀█████░ ██░ ██░│ 3 4 5 6 7 8 9│
║ Members Expanded #1 ║██░ ██░ ███▀███░ ▀██▀ ██░ ██░│10 11 12 13 14 15 16│
║ Members Expanded #2 ║██░ ██░ ██░ ██░ ██░ ██░ ██░│17 18 19 20 21 22 23│
║ Members Expanded #3 ║█▀███▀ ██░ ██░ ██░ ▀████▀ │24 25 26 27 28 29 30│
║ Ageing ║ │31 │
║ Notes (Member) ║ └────────────────────┘
║ Dump (Complete Data) ║╔════════════════════════════╗
║ Receipts Statements ║║ Member Records: 173 ║
║ Folder Labels ║╚════════════════════════════╝
║ Labels (Standard) ║
║ Big Labels ║
║ Payments ║█░ ██▄███░ ████░ ██▄███░ █████░ ██░ ██░ ████░ ██▄███░
║ Form Letters ║█░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
║ Browse Invoices ║█░ ██████░ ████░ ██████░ █████░ ██████░ ██░ ██▀███░
║ Invoices ║█░ ██░ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░
╟───────────────────────╢█░ ██▀███░ ████░ ██░▀██░ █████░ ██░ ██░ ████░ ██░
║ SELECT REPORT ║
╚═══════════════════════╝
Esc (Exit) Enter/Return (Select Report Option)
■ REPORTS/ROUTINES LIST
PRINTER SETUP FOLDER LABELS
MEMBERS LIST #1 LABELS (STANDARD)
MEMBERS LIST #2 BIG LABELS
MEMBERS EXPANDED #1 PAYMENTS
MEMBERS EXPANDED #2 FORM LETTERS
MEMBERS EXPANDED #3 BROWSE INVOICES
AGEING INVOICES
NOTES (MEMBER) CONFIG STATUS
DUMP (COMPLETE DATA) VIEW REPORTS ON SCREEN
RECEIPTS STATEMENTS
DAYO Membership, TJS LAB Page: 14
■ PRINTER SETUP
This routine was added to preclude you from having to get out of your
seat to change (mess with) the printer to get it to print correctly.
The most important printer selections (ie: font size, lines per inch,
orientation, ...) are made easy to evoke.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
║ ║
║ Select Option -> Eject ║
║ Line feed ║
║ Normal Size ║
║ Use this routine to set your Small/Condensed ║
║ printer up with one or more Bold On ║
║ of the setup strings and Bold Off ║
║ commands listed to the right. 6 Lines per Inch ║
║ 8 Lines per Inch ║
║ Select the 'Change Printer Print Landscape (Laser Only) ║
║ Default' option to change Print Portrait (Laser Only) ║
║ printer types. Reset Printer ║
║ Current printer is set to: Print Special String 1 ║
║ Okidata Print Special String 2 ║
║ Print Special String 3 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ PRINTER DRIVER OPTIONS
There are 18 printer driver options to select from. The last option is
to set the default printer, and the next to last is a 'SHELL' function that
runs a DOS command or program. The remainder are strings/codes that are sent
to the printer.
Eject Print Portrait (Laser Only)
Line feed Reset Printer
Normal Size Print Special String 1
Small/Condensed Print Special String 2
Bold On Print Special String 3
Bold Off Print Special String 4
6 Lines per Inch Print Special String 5
8 Lines per Inch Run DOS Command/Program
Print Landscape (Laser Only) Change Default Printer
DAYO Membership, TJS LAB Page: 15
■ CHANGE DEFAULT PRINTER
The last option is to change/set the default printer. This printer
driver routine comes with 4 default printer types, Epson, HP Laser, Star,
and Okidata.
You can add (Ctrl N) as many as you want.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Current Default Printer is set to: Okidata ║
╟────────────────────────────────────────────────────────────────────────────╢
║ NAME LINEFEED ║
║─────────────────────────────────────╥──────────────────────────────────────║
║ Epson & Compatibles ║ CHR(10) ║
║ HP Laser & Compatibles ║ CHR(10) ║
║ Star Micro Gemini ║ CHR(10) ║
║ Okidata ║ CHR(10) ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add)
1/4
DAYO Membership, TJS LAB Page: 16
■ FULL SCREEN EDIT - F2
When entering the printer codes, the string must be in the valid format
or it will not be printed later when requested...
┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
│ NAME: Epson & Compatibles │
│ LINEFEED: CHR(10) │
│ NORMAL: CHR(27)+CHR(18) │
│ SMALL: CHR(27)+CHR(15) │
│ BOLDON: CHR(27)+CHR(69) │
│ BOLDOFF: CHR(27)+CHR(70) │
│ _6LPI: CHR(27)+CHR(50) │
│ _8LPI: CHR(27)+CHR(48) │
│ PORTRAIT: │
│ LANDSCAPE: │
│ RESET: CHR(27)+CHR(64) │
│ SPEC_STR1: │
│ SPEC_STR2: │
│ SPEC_STR3: │
│ SPEC_STR4: │
│ SPEC_STR5: │
│ RUN_CMD: │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
NAME - Name of printer. Type in anything you wish here
LINEFEED - Code to advance printer one line
NORMAL - Normal font/character size
SMALL - Small font/character size
BOLDON - Bold/Emphasized
BOLDOFF - Bold/Emphasized off
_6LPI - Code to set printer to print 6 lines per inch
_8LPI - Code to set printer to print 8 lines per inch
PORTRAIT - Code to set lazer printer to print upright (normal)
LANDSCAPE - Code to set lazer printer to print sideways
RESET - Reset printer code
SPEC_STR1 - Any special printer string, ie: print double, skip perforation,
SPEC_STR2 - print very tiny, ...
SPEC_STR3 - "
SPEC_STR4 - "
SPEC_STR5 - "
RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
DAYO Membership, TJS LAB Page: 17
■ MEMBERS LIST #1
The Members List #1 is a simple, 80 column report that lists the members
Number, Name, Group, Type and Class fields.
Multiple indexes (6 of them), are available:
╔══════════════════════════▌ PRINT MEMBER LIST #1 ▐══════════════════════════╗
║█░ █░ ███░ █░ █░ █▄██░ ███░ █▄██░ █░ ███░ ████░ █████░ ██░ ║
║██▄██░ █░ ██▄██░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ ║
║█░█░█░ ██░ █░█░█░ ████░ ██░ ████░ █░ █░ ████░ █░ ▀█▀█▀ █░ ║
║█░█░█░ █░ █░█░█░ █░ █░ █░ █░█░ █░ █░ █░ █░ ▀█▀█▀ █░ ║
║█░ █░ ███░ █░ █░ █▀██░ ███░ █░██░ ████░ ███░ ████░ █░ ███░║
║ This report prints out a membership list containing the following fields: ║
║ MEMBER, NAME, GROUP, TYPE & CLASS ║
║ Options include: Index, Group, Type and/or Class. ║
║ ║
║ Select Index -> Member Number ║
║ Name ║
║ Firstname ║
║ Last 4 digits of Telephone ║
║ Zipcode ║
║ Group ║
║ Exit ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
The option to print only a specific Group, Type or Class is also
available.
A prompt will appear requesting the number of lines per page. The
default is 55 lines.
DAYO Membership, TJS LAB Page: 18
As in all DAYO Membership report routines, the report can be directed
to the printer (the default), or to a disk file.
╔══════════════════════════▌ PRINT MEMBER LIST #1 ▐══════════════════════════╗
║█░ █░ ███░ █░ █░ █▄██░ ███░ █▄██░ █░ ███░ ████░ █████░ ██░ ║
║██▄██░ █░ ██▄██░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ ║
║█░█░█░ ██░ █░█░█░ ████░ ██░ ████░ █░ █░ ████░ █░ ▀█▀█▀ █░ ║
║█░█░█░ █░ █░█░█░ █░ █░ █░ █░█░ █░ █░ █░ █░ ▀█▀█▀ █░ ║
║█░ █░ ███░ █░ █░ █▀██░ ███░ █░██░ ████░ ███░ ████░ █░ ███░║
║ This report prints out a membership list containing the following fields: ║
║ MEMBER, NAME, GROUP, TYPE & CLASS ║
║ Options include: Index, Group, Type and/or Class. ║
║ ║
║ Select Index -> Member Number ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ ║
║ Enter Number of Lines Per Page: 66 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: M1.TXT ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 19
■ PROGRESS GRAPH
Many of the report routines display a 'progress graph' onto the screen
as it prints the report, for example this 'Progress Glass' (Hour Glass):
╔══════════════════════════▌ PRINT MEMBER LIST #1 ▐════▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ ═══╗
║█░ █░ ███░ █░ █░ █▄██░ ███░ █▄██░ █░ ███░ █████┌──────────────┐█▒█░ ║
║██▄██░ █░ ██▄██░ █░ █░ █░ █░ █░ █░ █░ █░ █│ │█▒█░ ║
║█░█░█░ ██░ █░█░█░ ████░ ██░ ████░ █░ █░ █████│ │█▒█░ ║
║█░█░█░ █░ █░█░█░ █░ █░ █░ █░█░ █░ █░ ██│██████████████│█▒█░ ║
║█░ █░ ███░ █░ █░ █▀██░ ███░ █░██░ ████░ ███░ █████│██████████████│█▒██░║
║ This report prints out a membership list containing t█│██████████████│█▒: ║
║ MEMBER, NAME, GROUP, TYPE & CLASS█└─────╖ ╓─────┘█▒ ║
║ Options include: Index, Group, Type and/or Class. ███████║ ║███████▒ ║
║ ▄▄▄▄▄▄█║ ║█▄▄▄▄▄▄ ║
║ Select Index -> Member Number █┌─────╜ ╙─────┐█▒ ║
║ Print All Groups █│100% ██ │█▒ ║
║ Print All Types █│80% │█▒ ║
║ Print All Classes █│60% │█▒ ║
║ █│██████████████│█▒ ║
║ Enter Number of Lines Per Page: 66 █│██████████████│█▒ ║
║ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▒ ║
║ Send Output to Printer? (Y/N) ( No -> To File) █ PROGRESS GLASS █▒ ║
║ Enter File Name: M1.TXT ██████████████████▒ ║
║ ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
Standby, While I Print This Report... Esc (Exit)
■ MEMBER LIST #1 EXAMPLE
MEMBER LIST #1 Page: 1
Your Organization Date: 03/15/91
Time: 11:32:30
Options -> Indexed by Invoice Number
All Groups All Types All Classes
Member Name Group Type Class
------------ ------------------------------ -------- -------- --------
100030-TW Tony Watcher GROUP A3 Regular XXX
100031-TC Tracy Cromer GROUP A3 Regular XXX
100032-GM George Moonilal GROUP A3 Regular XXX
DAYO Membership, TJS LAB Page: 20
■ MEMBERS LIST #2
The Members List #2 is an 80 column report that lists the members
Number, Name and 4 blank 'columns'. Use this report to manually record
information, ie: attendance, scores...
Multiple indexes (6 of them), are available:
The option to print only a specific Group, Type or Class is also
available.
A prompt will appear requesting the number of lines per page. The
default is 55 lines.
The report can be directed to the printer (the default), or to a disk
file.
╔══════════════════════════▌ PRINT MEMBER LIST #2 ▐══════════════════════════╗
║█░ █░ ███░ █░ █░ █▄██░ ███░ █▄██░ █░ ███░ ████░ █████░ ████░║
║██▄██░ █░ ██▄██░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░║
║█░█░█░ ██░ █░█░█░ ████░ ██░ ████░ █░ █░ ████░ █░ ▀█▀█▀ ████░║
║█░█░█░ █░ █░█░█░ █░ █░ █░ █░█░ █░ █░ █░ █░ ▀█▀█▀ █░ ║
║█░ █░ ███░ █░ █░ █▀██░ ███░ █░██░ ████░ ███░ ████░ █░ ████░║
║ This report prints out a membership list that looks like the following: ║
║ MEMBER NAME (1) (2) (3) (4) ║
║ ------------ ------------------------------ ------- ------- ------- -------║
║ 10001 Rich LaRossa ------- ------- ------- -------║
║ 10002 Ron & Brenda Davidson ------- ------- ------- -------║
║ Options include: Index, Group, Type and/or Class. ║
║ Select Index -> Member Number ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ Enter Number of Lines Per Page: 66 ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: M2.TXT ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 21
■ MEMBERS EXPANDED #1
The Members Expanded Report #1 is a 132 column report that lists the
members Number, Name, Address, City, State, Zipcode, Phones 1 & 2, Group,
Type, Class, Lastdate, Nextdate, Balance, Dues, Payment Method (Code),
Customer Number and the member's Active status.
Multiple indexes (6 of them), are available:
The option to print only a specific Group, Type or Class is also
available.
A prompt will appear requesting the number of lines per page. The
default is 55 lines.
The report can be directed to the printer (the default), or to a disk
file.
╔═══════════════════════▌ EXPANDED MEMBER REPORT #1 ▐════════════════════════╗
║ ████░ █░ █░ █▄██░ █░ █░ █░ █▄██░ ████░ █▄██░ ██░ ║
║ █░ ▀█▄█▀ █░ █░ █▀█░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ ║
║ ███░ ▄█▄ ████░ █░█░ ███░█░ █░ █░ ███░ █░ █░ ▀█▀█▀ █░ ║
║ █░ ▄█░█▄ █░ █▀▀▀█░ █░███░ █░ █░ █░ █░ █░ ▀█▀█▀ █░ ║
║ ████░ █░ █░ █░ █░ █░ █░ ▀█░ █▀██░ ████░ █▀██░ ███░ ║
║ This report prints out an Expanded Membership Report containing the ║
║ following fields: MEMBER, NAME, ADDRESS, CITY, STATE, ZIP, PHONE1&2, GROUP,║
║ TYPE, CLASS, LASTDATE, NEXTDATE, BALANCE, DUES, PMETHOD, CUSTOMER, ACTIVE ║
║ Options include: Index, Group, Type and/or Class. Report is 132 columns! ║
║ Select Index -> Member Number ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ ║
║ Enter Number of Lines Per Page: 66 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: EX1.TXT ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 22
■ MEMBERS EXPANDED #2
The Members Expanded Report #2 is a 127 column report that lists the
members Number, Name, Address, City, State, Zipcode, Phones 1 & 2, Group,
Type, Class, Active status, and Comments.
Multiple indexes (6 of them), are available:
The option to print only a specific Group, Type or Class is also
available.
A prompt will appear requesting the number of lines per page. The
default is 55 lines.
The report can be directed to the printer (the default), or to a disk
file.
╔═══════════════════════▌ EXPANDED MEMBER REPORT #2 ▐════════════════════════╗
║ ████░ █░ █░ █▄██░ █░ █░ █░ █▄██░ ████░ █▄██░ ████░ ║
║ █░ ▀█▄█▀ █░ █░ █▀█░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ ║
║ ███░ ▄█▄ ████░ █░█░ ███░█░ █░ █░ ███░ █░ █░ ▀█▀█▀ ████░ ║
║ █░ ▄█░█▄ █░ █▀▀▀█░ █░███░ █░ █░ █░ █░ █░ ▀█▀█▀ █░ ║
║ ████░ █░ █░ █░ █░ █░ █░ ▀█░ █▀██░ ████░ █▀██░ ████░ ║
║ This report prints out an Expanded Membership Report containing the ║
║ following fields: MEMBER, NAME, ADDRESS, CITY, STATE, ZIP, PHONE1&2, GROUP,║
║ TYPE, CLASS, ACTIVE, & COMMENT ║
║ Options include: Index, Group, Type and/or Class. Report is 127 columns! ║
║ Select Index -> Member Number ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ ║
║ Enter Number of Lines Per Page: 66 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: EX2.TXT ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 23
■ MEMBERS EXPANDED #3
The Members Expanded Report #3 is a 127 column report that lists the
members Number, Name, Group, Type, Class, Lastdate, Nextdate, Balance, Dues,
Payment Method (Code) and Active status.
Multiple indexes (6 of them), are available:
The option to print only a specific Group, Type or Class is also
available.
A prompt will appear requesting the number of lines per page. The
default is 55 lines.
The report can be directed to the printer (the default), or to a disk
file.
╔═══════════════════════▌ EXPANDED MEMBER REPORT #3 ▐════════════════════════╗
║ ████░ █░ █░ █▄██░ █░ █░ █░ █▄██░ ████░ █▄██░ ████░ ║
║ █░ ▀█▄█▀ █░ █░ █▀█░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ ║
║ ███░ ▄█▄ ████░ █░█░ ███░█░ █░ █░ ███░ █░ █░ ▀█▀█▀ ███░ ║
║ █░ ▄█░█▄ █░ █▀▀▀█░ █░███░ █░ █░ █░ █░ █░ ▀█▀█▀ █░ ║
║ ████░ █░ █░ █░ █░ █░ █░ ▀█░ █▀██░ ████░ █▀██░ ████░ ║
║ This report prints out an Expanded Membership Report containing the ║
║ following fields: MEMBER, NAME, GROUP, TYPE, CLASS, LASTDATE, NEXTDATE, ║
║ BALANCE, DUES, PMETHOD, ACTIVE ║
║ Options include: Index, Group, Type and/or Class. Report is 127 columns! ║
║ Select Index -> Member Number ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ ║
║ Enter Number of Lines Per Page: 66 ║
║ Paper Economizing... ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: EX3.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 24
■ AGEING
The Ageing report prints out a listing of your members which includes
accounting information and the 'age' in days of a members dues. The report
is 132 columns wide, and contains the following fields: Member Number, Name,
Group, Type, Class, Payment Method/Code, Age (in days), Lastdate, Nextdate,
Dues, Balanc and Pastdue amount.,
Multiple indexes (6 of them), are available:
The option to print only a specific Group, Type or Class is also
available.
A prompt will appear requesting the number of lines per page. The
default is 55 lines.
The report can be directed to the printer (the default), or to a disk
file.
A special conditional option is to print only those members that are
past due:
╔════════════════════════════════════════════════════════════════════════════╗
║ ████░ ███████░ ██████░ ████░ ██░ ██░ ███████░ ║
║ ██░ ██░ ██░ ██░ ██░ ███░██░ ██░ ║
║ ██░ ██░ ██░ ▀██░ ████░ ██░ ██████░ ██░ ▀██░ ║
║ ███▀▀███░ ██░ ██░ ██░ ██░ ██░███░ ██░ ██░ ║
║ ██░ ██░ ███████░ ██████░ ████░ ██░ ██░ ███████░ ║
║ This reports dues/donation status based on the DUES, BALANCE, and ║
║ payment schedule for each member. ║
╟────────────────────────────────────────────────────────────────────────────╢
║ ║
║ Select Index -> Member Number ║
║ ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ ║
║ Select Dues Option -> Pastdue ║
║ Due (Includes Pastdue) ║
║ All Members ║
║ Exit ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Abort)
DAYO Membership, TJS LAB Page: 25
■ NOTES (MEMBER)
If required, you can print out any/all information typed into a specific
or all members notes. The notes have a column width of 78 characters. Note,
form feeds (page ejects) are performed between each members notes. Nothing
prints if no notes exist for a member...
If all members are selected, then the Multiple Indexes, Group, Type and
Class options will be made available.
Multiple indexes (6 of them), are available:
The option to print only a specific Group, Type or Class is also
available.
A prompt will appear requesting the number of lines per page. The
default is 55 lines.
The report can be directed to the printer (the default), or to a disk
file.
╔════════════════════════════▌ PRINT MEMBER NOTES ▐══════════════════════════╗
║ █░ █░ ███░ █░ █░ █▄██░ ███░ █▄██░ █░ █░ ▄██▄ █████░ ███░ ████░ ║
║ ██▄██░ █░ ██▄██░ █░ █░ █░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ ║
║ █░█░█░ ██░ █░█░█░ ████░ ██░ ████░ ███░█░ █░ █░ █░ ██░ ████░ ║
║ █░█░█░ █░ █░█░█░ █░ █░ █░ █░█░ █░███░ █░ █░ █░ █░ █░ ║
║ █░ █░ ███░ █░ █░ █▀██░ ███░ █░██░ █░ ▀█░ ▀██▀ █░ ███░ ████░ ║
║ This report prints out member(s) notes to printer or file. ║
║ Options include: Specific Member, Index, Group, Type and/or Class. ║
║ Form feeds (page ejects) are performed between each member's notes. ║
║ Is this for a Specific Member? (Y/N) ║
║ Select Index -> Member Number ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ ║
║ Enter Number of Lines Per Page: 66 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: NOTES.TXT ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 26
■ DUMP (COMPLETE DATA)
Use this report (actually 4 in 1) to report everything recorded about
a member or all members. If you print for all members, if may take quite a
long time (depending on the size and quantity of data).
This reports consists of a report of all database fields, an invoice
report, a payments report, and a printout of the member's notes.
If all members are selected, then the Multiple Indexes, Group, Type and
Class options will be made available.
Multiple indexes (6 of them), are available:
The option to print only a specific Group, Type or Class is also
available.
A prompt will appear requesting the number of lines per page. The
default is 55 lines.
The report can be directed to the printer (the default), or to a disk
file.
╔══════════════════════════════▌ MEMBER DUMP ▐═══════════════════════════════╗
║ █░ █░ ███░ █░ █░ █▄██░ ███░ █▄██░ █▄███░ █░ █░ █░ █░ █▄███░ ║
║ ██▄██░ █░ ██▄██░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ██▄██░ █░ █░ ║
║ █░█░█░ ██░ █░█░█░ ████░ ██░ ████░ █░ █░ █░ █░ █░█░█░ █████░ ║
║ █░█░█░ █░ █░█░█░ █░ █░ █░ █░█░ █░ █░ █░ █░ █░█░█░ █░ ║
║ █░ █░ ███░ █░ █░ █▀██░ ███░ █░██░ █▀███░ █████░ █░ █░ █░ ║
║ This report prints out 'everything' about a member. Prints for all or ║
║ a specific member. Other options include: Index, Group, Type and/or Class. ║
║ Form feeds (page ejects) are performed between each member's data. ║
║ Is this for a Specific Member? (Y/N) ║
║ Select Index -> Member Number ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ ║
║ Enter Number of Lines Per Page: 66 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: NOTES.TXT ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 27
■ MEMBER DUMP EXAMPLE - PART 1
DUMP For Member: 100030-TW Page: 1
Tony Watcher (Blockhead)
3939 Easter Lane Date: 03/15/91
# 393
Sumter, SC 55555-5555 Time: 12:46:21
(800) 123-4567
------------------------------------------------------------------------------
Field Name Contents
------------ ------------------------------------------------------------
MEMBER 100030-TW
NAME Tony Watcher
FIRSTNAME Blockhead
ADDRESS1 3939 Easter Lane
ADDRESS2 # 393
CITY Sumter
STATE SC
ZIP 55555-5555
PHONE1 (800) 123-4567
PHONE2
DATE 03/04/89
LASTDATE 12/11/90
NEXTDATE 05/01/93
BALANCE 944.00
DUES 10.00
PAYHIST 56.00
GROUP GROUP A3
TYPE Regular
CLASS XXX
FAX
CUSTOMER 30012
COMMENT
PMETHOD 3
ACTIVE T
■ MEMBER DUMP EXAMPLE - PART 2
INVOICE REPORT - Member: 100030-TW (Tony Watcher)
Date: 03/15/91 Page: 2
Invoice Amount Description Date
-------- ---------- ------------------------------ --------
1022 10.00 Monthly Dues 01/12/90
1227 10.00 Monthly Dues 02/13/90
1561 10.00 Monthly Dues 03/10/90
2021 10.00 Monthly Dues 04/09/90
----------
40.00
DAYO Membership, TJS LAB Page: 28
■ MEMBER DUMP EXAMPLE - PART 3
PAYMENTS/DONATIONS REPORT - Member: 100030-TW (Tony Watcher)
Date: 03/15/91 Page: 3
Payment Amount Description/Check Info Date
------- ---------- ------------------------------ --------
2344 10.00 Check # 33833 (Late!) 02/12/91
3231 10.00 Check # 33938 (Late!) 03/23/91
4012 10.00 Check # 34001 (Late!) 04/11/91
4995 10.00 Check # 34432 (Late!) 05/26/91
----------
40.00
■ MEMBER DUMP EXAMPLE - PART 4
DUMP For Member: 100030-TW Page: 4
Tony Watcher (Blockhead)
3939 Easter Lane Date: 03/15/91
# 393
Sumter, SC 55555-5555 Time: 12:46:27
(800) 123-4567
------------------------------------------------------------------------------
Type in anything you wish about a member.
Use it to record up to 16,000 bytes of information (up to 18 pages)...
DAYO Membership, TJS LAB Page: 29
■ RECEIPTS STATEMENTS
This report lists all payments. Besides the members name and address,
the amount of each payment, description and payment date is also printed.
A date range option is used. Enter the start and ending dates you wish
to include in this report.
Multiple indexes (6 of them), are available:
The option to print only a specific Group, Type or Class is also
available.
The report can be directed to the printer (the default), or to a disk
file.
╔════════════════════════════════════════════════════════════════════════════╗
║██████░ ██████░ ███░ ██████░ █████░ ██░ ██░ █████░ ██░ ██░ ██████░ █████░║
║██░ ██░ ██░██░ ██░ ██░ ███░███░ ██░ ███░██░ ██░ ██░ ║
║██████░ ██░ ██░██░ ██░ ████░ ███████░ ████░ ██████░ ██░ █████░║
║ ██░ ██░ ███████░ ██░ ██░ ██░█░██░ ██░ ██░███░ ██░ ██░║
║██████░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ █████░ ██░ ██░ ██░ █████░║
║ This reports receipts of payments/dues/donations for each member. ║
║ Options include: Index, Pastdue or Due, Group, Type and/or Class. ║
║ Form feeds (page ejects) between member's statements. ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Enter Start Date: 03/06/90 End Date: 05/06/91 ║
║ Select Index -> Member Number ║
║ Print All Groups ║
║ Print All Types ║
║ Print All Classes ║
║ ║
║ Select Dues Option -> All Members ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: STMTS.TXT ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Abort)
DAYO Membership, TJS LAB Page: 30
■ FOLDER LABELS
Folder labels are printed only in batches, based on a specific Group,
Type and/or Class. The Folder label is printed onto a standard tracker fed
label (3.5" by 15/16"). The member's Number, Name, Group and Type is the
only data printed onto the label.
Multiple indexes (6 of them), are available:
An option exists to print multiple copies of each label (1-9).
The labels can be directed to the printer (the default), or to a disk
file.
╔════════════════════════════════════════════════════════════════════════════╗
║█████░ ▄████▄ ██░ ██▄███░ █████░ ██▄███░│■┌──────────────────────────┐■│║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░│■│Member: 10000-TJS │■│║
║████░ ██░ ██░ ██░ ██░ ██░ ████░ ██████░│■│Terry Jerome Smith │■│║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ │■│ Group: GROUP A │■│║
║██░ ▀████▀ █████░ ██▀███░ █████░ ██░ ██░│■│ Type: EXCEPT │■│║
║ Batch Folder Labels for Standard Label │■└──────────────────────────┘■│║
║ │■┌──────────────────────────┐■│║
║ Select │■│Member: 10001-MZ │■│║
║ Index -> Member Number │■│Mike Zelek │■│║
║ Print All Groups │■│ Group: GROUP A │■│║
║ Print All Types │■│ Type: OKDUDE │■│║
║ Print All Classes │■└──────────────────────────┘■│║
║ │■┌──────────────────────────┐■│║
║ Enter Number of Copies Each: 1 │■│Member: 10002-EW │■│║
║ │■│Eva Woodard │■│║
║ Send Output to Printer? (Y/N) No-> to File │■│ Group: GROUP B │■│║
║ │■│ Type: TALKALOT │■│║
║ Enter File Name: FLABELS.TXT │■└──────────────────────────┘■│║
║ │■┌─────────────────────────┐ ■│║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 31
■ PROGRESS GRAPH FOR LABELS
When the Folder or Regular labels are printing, a progress graph is
displayed at the bottom of the screen and the labels are scrolled onto the
right side of the screen:
╔════════════════════════════════════════════════════════════════════════════╗
║█████░ ▄████▄ ██░ ██▄███░ █████░ ██▄███░│■└──────────────────────────┘■│║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░│■┌──────────────────────────┐■│║
║████░ ██░ ██░ ██░ ██░ ██░ ████░ ██████░│■│Member: 36633 │■│║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ │■│Gena LaBagia │■│║
║██░ ▀████▀ █████░ ██▀███░ █████░ ██░ ██░│■│ Group: A │■│║
║ Batch Folder Labels for Standard Label │■│ Type: S │■│║
║ │■└──────────────────────────┘■│║
║ Select │■┌──────────────────────────┐■│║
║ Index -> Member Number │■│Member: 36789 │■│║
║ Print All Groups │■│Tina LaBagia │■│║
║ Print All Types │■│ Group: A │■│║
║ Print All Classes │■│ Type: S │■│║
║ │■└──────────────────────────┘■│║
║ Enter Number of Copies Each: 1 │■┌──────────────────────────┐■│║
║ │■│Member: 36799 │■│║
║ Send Output to Printer? (Y/N) No-> to File │■│Harry Harper Harold │■│║
║ │■│ Group: H │■│║
║ Enter File Name: FLABELS.TXT │■│ Type: B │■│║
║ │■└──────────────────────────┘■│║
╚════════════════════════════════════════════════════════════════════════════╝
├██████████████────────────────────┼──────────────────────────────────┤
│0%───────────────────────────────50%───────────────────────────────Finis
Standby, While I Print These Labels... Esc (Exit)
■ LABELS (STANDARD)
These address labels are printed only in batches. Use the label printing
function in the members browse to print single address labels. This address
label is printed onto a standard tracker fed label (3.5" by 15/16"). The
member's Name, Address1, Address2 (if not empty), and the City+State+Zipcode
is printed onto the labels.
The option to print only a specific Group, Type or Class is also
available.
Multiple indexes (6 of them), are available:
DAYO Membership, TJS LAB Page: 32
An option exists to print multiple copies of each label (1-9).
The labels can be directed to the printer (the default), or to a disk
file.
╔════════════════════════════════════════════════════════════════════════════╗
║██░ ███░ ██▄███░ █████░ ██░ █████░│■┌──────────────────────────┐■│║
║██░ ██░██░ ██░ ██░ ██░ ██░ ██░ │■│Terry Jerome Smith, Inc │■│║
║██░ ██▄██░ ██████░ ████░ ██░ █████░│■│1234 Blanchard Road │■│║
║██░ ██▀ ▀██░ ██░ ██░ ██░ ██░ ██░│■│North Augusta, SC 14892 │■│║
║█████░ ██░ ██░ ██▀███░ █████░ █████░ █████░│■│ │■│║
║ │■└──────────────────────────┘■│║
║ Batch Label Printing On Standard Labels │■┌──────────────────────────┐■│║
║ Select │■│Andy Altizer (Cpt P.) │■│║
║ Index -> Member Number │■│145 East Langdon St │■│║
║ Print All Groups │■│Suite 23 │■│║
║ Print All Types │■│San Fransisco, CA 39393 │■│║
║ Print All Classes │■└──────────────────────────┘■│║
║ │■┌──────────────────────────┐■│║
║ Enter Number of Copies Each: 1 │■│Marus Edo DeFalsi │■│║
║ │■│#5 Georgetown │■│║
║ Send Output to Printer? (Y/N) No-> to File │■│Cap de la Madre │■│║
║ │■│Quebec, Canada G8T 8W2 │■│║
║ Enter File Name: LABELS.TXT │■└──────────────────────────┘■│║
║ │■┌─────────────────────────┐ ■│║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
■ BIG LABELS
If you want to print a large label (yow can define its size), then use
this routine. Big labels are useful in shipping boxes & packages, and are
usually more colorful (better image for your organization).
Big labels are not printed in batch, and can only be directed to the
printer (not to a disk file).
DAYO Membership, TJS LAB Page: 33
Multiple search indexes (6 of them), are available:
██▄████░ ████░ ▄██████░ │■│┌───────────────────────────────┐│■│
██░ ██░ ██░ ██░ │■││ Your Association Name ││■│
██░ ██░ ██░ ██░ │■││ 12345 Orange Street ││■│
██████░ ██░ ██░ ███░ │■││ Suite 100A ││■│
██░ ██░ ██░ ██░ ██░ │■││ Anyplace, ST 12345-1234 ││■│
██░ ██░ ██░ ██░ ██░ │■│├───────────────────────────────┤│■│
██▀████░ ████░ ▀██████▀ │■││ Member Name Goes Here ││■│
│■││ Address Line Here ││■│
█░ ▄█▄ █▄██░ ███░ █░ ▄██▄ │■││ Another Address Line ││■│
█░ █░█░ █░ █░ █░ █░ █░ │■││ City, State, ZIP ││■│
█░ █▄█░ █▄▄█░ ██░ █░ █▄▄▄ │■│└───────────────────────────────┘│■│
█░ █▀ ▀█░ █░ █░ █░ █░ █░ │■│┌───────────────────────────────┐│■│
███░ █░ █░ █▀██░ ███░ ███░ ▀██▀ │■││ Sally Morgan ││■│
╔════════════════════════════════════════════════════════════════════════════╗
║Select Label Option -> Print Member Label(s) ║
║ Label Configuration ║
║ Line Feed ║
║ Exit ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
To print a big label, select the 'Print Member Label(s)' option, find
the selected member record (using the Find keys F5-F10), then press the
Enter/Return to print it.
██▄████░ ████░ ▄██████░ │■│┌───────────────────────────────┐│■│
██░ ██░ ██░ ██░ │■││ Your Association Name ││■│
██░ ██░ ██░ ██░ │■││ 12345 Orange Street ││■│
██████░ ██░ ██░ ███░ │■││ Suite 100A ││■│
██░ ██░ ██░ ██░ ██░ │■││ Anyplace, ST 12345-1234 ││■│
██░ ██░ ██░ ██░ ██░ │■│├───────────────────────────────┤│■│
██▀████░ ████░ ▀██████▀ │■││ Member Name Goes Here ││■│
│■││ Address Line Here ││■│
█░ ▄█▄ █▄██░ ███░ █░ ▄██▄ │■││ Another Address Line ││■│
█░ █░█░ █░ █░ █░ █░ █░ │■││ City, State, ZIP ││■│
█░ █▄█░ █▄▄█░ ██░ █░ █▄▄▄ │■│└───────────────────────────────┘│■│
█░ █▀ ▀█░ █░ █░ █░ █░ █░ │■│┌───────────────────────────────┐│■│
███░ █░ █░ █▀██░ ███░ ███░ ▀██▀ │■││ Sally Morgan ││■│
╔════════════════════════════════════════════════════════════════════════════╗
║ MEMBER NAME FIRSTNAME ║
║───────────────────╥────────────────────────────────╥───────────────────────║
║ 100030-TW ║ Tony Watcher ║ Blockhead ║
║ 100031-TC ║ Tracy Cromer ║ Tracy ║
║ 100032-GM ║ George Moonilal ║ George ║
║ 100033-MWG ║ Mark Winston Greathouse ║ Mark ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) Enter/Return (Print)
Find: F5(Member) F6(Name) F7(Firstname) F8(Phone) F9(Zipcode) F10(Group)
DAYO Membership, TJS LAB Page: 34
■ BIG LABEL CONFIGURATION
The options available to setup/configure the Big label are listed
on the screen print below:
██▄████░ ████░ ▄██████░ │■│┌───────────────────────────────┐│■│
██░ ██░ ██░ ██░ │■││ Your Association Name ││■│
██░ ██░ ██░ ██░ │■││ 12345 Orange Street ││■│
██████░ ██░ ██░ ███░ │■││ Suite 100A ││■│
██░ ██░ ██░ ██░ ██░ │■││ Anyplace, ST 12345-1234 ││■│
██░ ██░ ██░ ██░ ██░ │■│├───────────────────────────────┤│■│
██▀████░ ████░ ▀██████▀ │■││ Member Name Goes Here ││■│
╔════════════════════════════════════════════════════════════════════╗│■│
█░║ Print Your Association Address: Y ║│■│
█░║ Print Firstname: Y ║│■│
█░║ Number of Lines per Label: 18 ║│■│
█░║ Label Width (for centering): 40 ║│■│
██║ Starting Column: 0 ║│■│
╔═══║ Starting Line For Your Address: 5 ║═══╗
║Sel║ Starting Line For Addressee: 12 ║ ║
║ ║ ║ ║
║ ║ ║ ║
║ ║ ║ ║
║ ║ ║ ║
║ ╚════════════════════════════════════════════════════════════════════╝ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO Membership, TJS LAB Page: 35
■ PAYMENTS
This report lists all payments for all members selected. The following
fields/data is printed: Payment Number, Member Number, Date of Transaction,
Description/Check Information, Payment Amount, Group, Type and Class.
Two (2) indexes are available:
╔═════════════════════════▌ PRINT PAYMENTS REPORT ▐══════════════════════════╗
║ This report prints out all payment records that meet Index, Date, Group, ║
║ Type and/or Class options/conditions. This report can also be printed ║
║ for a specific member or all members. ║
║ ║
║ Select Index -> Payment Number ║
║ Member Number ║
║ Exit ║
║ ║
║ █▄████░ ▄█▄ █░ █░ █░ █░ ████░ █░ █░ █████░ █████░ ║
║ █░ █░ █░█░ █▄ ▄█░ ██░██░ █░ ██░ █░ █░ █░ ║
║ █▀████░ █▄█░ █▄█░ █████░ ███░ ███░█░ █░ █████░ ║
║ █░ █▀ ▀█░ █░ █░█░█░ █░ █░███░ █░ █░ ║
║ █░ █░ █░ █░ █░ █░ ████░ █░ ██░ █░ █████░ ║
║ ║
║ █▄███░ ████░ █▄███░ ▄███▄ █▄███░ █████░ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ █████░ ██░ █████░ █░ █░ █████░ █░ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ █░ ██░ ████░ █░ ▀███▀ █░ ██░ █░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
A date range option (start and end dates for the report), is provided.
The option to print only a specific Group, Type or Class is also
available.
DAYO Membership, TJS LAB Page: 36
The report can be directed to the printer (the default), or to a disk
file.
DAYO Membership Version 1.1 TJS LAB REPORTS
╔══════════════════════════▌ PRINT PAYMENTS REPORT ▐═════════════════════════╗
║ This report prints out all payment records that meet Index, Date, Group, ║
║ Type and/or Class options/conditions. This report can also be printed ║
║ for a specific member or all members. ║
║ ║
║ Select Index -> Member Number ║
║ ║
║ Start Date: 03/06/90 End Date: 05/06/91 ║
║ ║
║ All Members Selected ║
║ ║
║ Print All Groups ║
║ ║
║ Print All Types ║
║ ║
║ Print All Classes ║
║ ║
║ Enter Number of Lines Per Page: 66 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
■ PAYMENT REPORT EXAMPLE
PAYMENT REPORT Page: 1
Your Organization Date: 03/15/91
Time: 14:41:43
Options -> Indexed by Member Number For all members
All Groups All Types All Classes
Payment Description/Check Info Amount Group Type Class
-------- ------------------------------ ---------- -------- -------- --------
1929 Check # 33838 (Late!) 10.00 B Regular 0
(100031-TW) 02/02/91
1930 Check #9393 10.00 B Regular 1
(100032-FGH) 03/05/91
1931 Check #9393 5.00 A Regular XXX
(100033-RTS) 03/05/91
1932 Cash 10.00 C Regular Z
(100034-TDS) 03/05/91
1933 Cash 10.00 C Regular XXX
(100035-RT) 03/05/91
1934 Money Order# 34939 10.00 Z Regular Z
(100036-EX) 03/05/91
------------
*** Report Total -> 55.00
DAYO Membership, TJS LAB Page: 37
■ FORM LETTERS
This routine can be very useful in any association or organization that
frequently do 'mailings' of letters or notices. This routine lets you create,
modify and print form letters (mail merge), to selected (or all) members.
Any field in the members database (MEMBERS.DBF) plus 'TODAY' (today's date),
can be incorporated into the form letter by simply placing a '<' character
before the field, and a '>' after it, ie: <NAME>
╔════════════════════════════════════════════════════════════════════════════╗
║ ████░ ▄███▄ █▄██░ ██░██░ █░ ████░ █████░ █████░ ████░ █▄██░ ████░ ║
║ █░ █░ █░ █░ █░ █████░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ ███░ █░ █░ ████░ █░█░█░ █░ ███░ █░ █░ ███░ ████░ ████░ ║
║ █░ █░ █░ █░█░ █░█░█░ █░ █░ █░ █░ █░ █░█░ █░ ║
║ █░ ▀███▀ █░██░ █░ █░ ████░ ████░ █░ █░ ████░ █░██░ ████░ ║
║ This very special routine provides you a means to create form letters ║
║ ('mail merge') that integrate with the members database (MEMBERS.DBF). ║
║ An example of the 'format' for using member database fields is: ║
║ <MEMBER>, <NAME>, <ADDRESS>, <DUES>, <BALANCE>, <TODAY> &/or <COMMENT> ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Select Option -> Edit/Modify Existing Letter ║
║ Create New Form Letter ║
║ Print Letter ║
║ Exit ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
■ CREATE NEW FORM LETTER
Every form letter must have a unique name (up to 8 characters). The
extension will always be '.LET' and implied, so you never have to enter it...
At the prompt for new form letter name, enter a unique (not case sensitive)
file name.
As a default, each new form letter contains form letter codes for todays
date, Member's name, address & phone, your organization name, address &
phone, and a 'Dear Firstname' statement.
DAYO Membership, TJS LAB Page: 38
■ EDIT/MODIFY EXISTING FORM LETTER
At the prompt for form letter name, you can type the name in, or press
Enter/Return on an empty field to bring up a selection window of all current
form letters, ie:
╔════════════════════════════════════════════════════════════════════════════╗
║ ████░ ▄███▄ █▄██░ ██░██░ █░ ████░ █████░ █████░ ████░ █▄██░ ████░ ║
║ █░ █░ █░ █░ █░ █████░ █░ █░ █░ ┌───────────────────────┐║
║ ███░ █╔══════════▌ SELECT FORM LETTER FILE ▐═╗ │ Highlight a file │║
║ █░ █║ Letter Name Size Date ║ │ using the arrow │║
║ █░ ▀╟──────────────┬────────────┬──────────╢ │ keys, then press │║
║ This ve║TEMP.LET │ 201 │ 02/12/91 ║to │ Enter/Return. │║
║ ('mail ║SAMPLE.LET │ 587 │ 02/15/91 ║dat└───────────────────────┘║
║ An exam║LETTER1.LET │ 226 │ 02/12/91 ║abase fields is: ║
║ <MEMBER║SALLEY.LET │ 226 │ 02/15/91 ║ <TODAY> &/or <COMMENT> ║
╟────────║LETTER2.LET │ 261 │ 02/12/91 ║────────────────────────────╢
║ Select ║LETTER3.LET │ 206 │ 02/12/91 ║ ║
║ ╚══════════════╧════════════╧══════════╝ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 39
■ FORM LETTER EDITOR
You will be presented with a very simple editor. Press the F1 key once
to bring up a window explaining all the special keys.
DAYO Form Letters Letter Name: FD
<<DATE>>
To: <<NAME>>
<<ADDRESS>>
<<PHONE1>>
From: Your Organization
Attn: Memberships
P.O. Box 5555
Anycity, FL 555555-5555
<DATE>
<TODAY>
<PHONE>
Active: <ACTIVE>
Esc (Abort) Ctrl W (Save & Exit) F1 (Help) F2 (Import) F3 (Fields)
<INSERT ON> 12/0
■ IMPORT TEXT FILE INTO FORM LETTER - F2
Press F2 to import an existing text or form letter into the current
form letter file:
┌────────────────────────────────────────────────────────────────────────────┐
│ This routine will merge a text file with your current file/memo/mail. │
│ Enter FILE NAME: TEMP.LET │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 40
■ VIEW FIELDS (VALID FORM LETTER CODES) - F3
If you forget what all the member database fields are, press F3 to
display them onto the screen, ie:
╔════════════════▌ FIELDS (VALID FORM LETTER CODES) ▐═════════════════╗
║ MEMBER GROUP ________ ║
║ NAME TYPE ________ ║
║ FIRSTNAME CLASS ________ ║
║ ADDRESS1 FAX ________ ║
║ ADDRESS2 CUSTOMER ________ ║
║ CITY COMMENT ________ ║
║ STATE PMETHOD ________ ║
║ ZIP ACTIVE ________ ║
║ PHONE1 ________ ________ ║
║ PHONE2 ________ ________ ║
║ DATE ________ ________ ║
║ LASTDATE ________ ________ ║
║ NEXTDATE ________ ________ ║
║ BALANCE ________ ________ ║
║ DUES ________ ________ ║
║ PAYHIST ________ ________ ║
╚═════════════════════════════════════════════════════════════════════╝
Press any key to continue...
■ BROWSE INVOICES
╔════════════════════════════▌ BROWSE INVOICES ▐═════════════════════════════╗
║ INVOICE MEMBER AMOUNT DESC ║
║────────────╥──────────────╥────────────╥───────────────────────────────────║
║ 12334 ║ 100030-TW ║ 10.00 ║ Monthly Dues ║
║ 12335 ║ 100031-OPM ║ 10.00 ║ Monthly Dues ║
║ 12336 ║ 100032-AC ║ 10.00 ║ Monthly Dues ║
║ 12337 ║ 100033-DC ║ 10.00 ║ Monthly Dues ║
║ 12338 ║ 100034-AC ║ 10.00 ║ Monthly Dues ║
║ 12339 ║ 100435-DS ║ 10.00 ║ Monthly Dues ║
║ 12340 ║ 100036-CTG ║ 10.00 ║ Monthly Dues ║
║ 12341 ║ 100037-MWG ║ 10.00 ║ Monthly Dues ║
║ 12342 ║ 100238-MJ ║ 10.00 ║ Monthly Dues ║
║ 12343 ║ 100045-MG ║ 10.00 ║ Monthly Dues ║
║ 12344 ║ 100260-SJ ║ 10.00 ║ Monthly Dues ║
║ 12345 ║ 100275-GM ║ 10.00 ║ Monthly Dues ║
║ 12346 ║ 102547-DG ║ 10.00 ║ Monthly Dues ║
║ 12347 ║ 100570-TSD ║ 40.00 ║ Monthly Dues ║
║ 12348 ║ 100075-DDS ║ 10.00 ║ Monthly Dues ║
║ 12349 ║ 101022-DR ║ 10.00 ║ Monthly Dues ║
║ 12350 ║ 100034-RL ║ 10.00 ║ Monthly Dues ║
║ 12351 ║ 100191-TA ║ 10.00 ║ Monthly Dues ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) F3 (Member Info) Alt B (Reprint)
Find: F5 (Invoice Number) F6 (Member Number)
DAYO Membership, TJS LAB Page: 41
■ FULL SCREEN EDIT - F2
╔════════════════════════════▌ FULL SCREEN EDIT ▐════════════════════════════╗
║ INVOICE: 12334 ║
║ MEMBER: 100030-TW ║
║ AMOUNT: 10.00 ║
║ DESC: Monthly Dues ║
║ DATE: 03/06/91 ║
║ TYPE: Regular ║
║ CLASS: XXX ║
║ GROUP: GROUP A ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (ABORT & Exit) F1 (Help) PgUp/PgDn (SAVE & Exit)
■ DISPLAY MEMBER INFORMATION - F3
╔═══════════════════════════▌ MEMBER INFORMATION ▐═══════════════════════════╗
║ Member: 100030-TW Name: Tony Watcher (Blockhead) ║
║ Phone #1: (800) 123-4567 3939 Easter Lane Date: 03/04/89║
║ Phone #2: # 393 Class: XXX ║
║ Group: GROUP A3 Method: 3 Sumter, SC 55555-5555 Type: Regular ║
║ Last: 12/11/90 Next: 05/01/93 Dues: 10.00 Balance: 944.00║
║ Comment: <ACTIVE> ║
╚════════════════════════════════════════════════════════════════════════════╝
Press any key to continue...
DAYO Membership, TJS LAB Page: 42
■ INVOICES
╔══════════════════════════▌ PRINT INVOICE REPORT ▐══════════════════════════╗
║ This report prints out all invoice records that meet Index, Date, Group, ║
║ Type and/or Class options/conditions. This report can also be printed ║
║ for a specific member or all members. ║
║ ║
║ Select Index -> Invoice Number ║
║ Member Number ║
║ Exit ║
║ ║
║ ███░ █░ █░ █░ █░ ▄███▄ ███░ ▄███░ ████░ ║
║ █░ ██░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ █░ ███░█░ █▄ ▄█░ █░ █░ █░ █░ ██░ ║
║ █░ █░███░ █▄█░ █░ █░ █░ █░ █░ ║
║ ███░ █░ ██░ █░ ▀███▀ ███░ ▀███░ ████░ ║
║ ║
║ █▄███░ ████░ █▄███░ ▄███▄ █▄███░ █████░ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ █████░ ██░ █████░ █░ █░ █████░ █░ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ █░ ██░ ████░ █░ ▀███▀ █░ ██░ █░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
╔══════════════════════════▌ PRINT INVOICE REPORT ▐══════════════════════════╗
║ This report prints out all invoice records that meet Index, Date, Group, ║
║ Type and/or Class options/conditions. This report can also be printed ║
║ for a specific member or all members. ║
║ ║
║ Select Index -> Member Number ║
║ ║
║ Start Date: 03/06/90 End Date: 05/06/91 ║
║ ║
║ All Members Selected ║
║ ║
║ Print All Groups ║
║ ║
║ Print All Types ║
║ ║
║ Print All Classes ║
║ ║
║ Enter Number of Lines Per Page: 66 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Membership, TJS LAB Page: 43
■ CONFIG STATUS
╔═══════════════════════════════════════════════════════╗
║The Configuration Status Settings Report lists all of ║
║configuration settings (found in file DAYOMEM.CFG). ║
║This is Not a Report Form. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: CONFIG.TXT ║
╚═══════════════════════════════════════════════════════╝
■ CONFIG STATUS REPORT EXAMPLE
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ DAYO MEMBERSHIP CONFIGURATION REPORT +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
03/16/91
02:30:24
Association or Company Name: Your Organization
Address Line 1: Attn: Memberships
Address Line 2: P.O. Box 5555
City, State Zip: Anycity, FL 555555-5555
Telephone: 800-555-5555
Last Member Number: 1ST-MEMBER
Customer Database Location: \DAYOAR\
Current Directory:
Form Letter Location: \DAYOMEM\
Report Printer Type: STANDARD PRINTER
Report Printer Port: LPT1
Visual Indexing: Yes
Automatically Reindex Daily: Yes
Color: Yes
High Intensity: Yes
Default Payment Method: 6
1 - Each Month at a Specified Day (15)
2 - Every 2 Months at a Specified Day (1)
3 - Every 3 Months (Quarterly) at a Specified Day (1)
4 - Every 6 Months (Semi-annually) at a Specified Day (1)
5 - Every Year (Annually) at a Specified Day (31)
6 - Every 60 Number of Days
7 - Every 90 Number of Days
8 - Every 90 Number of Days
DAYO Membership, TJS LAB Page: 44
Configuration Status Report Continued...
Payment Printer Port: LPT1
Payment Copies: 1
Automatically Print Payments: Yes
Statement Printer Port: LPT1
Statement Copies: 1
Labels Printer Port: LPT1
Automatically Print Labels: No
Print Balance On Payment: Yes
Default Payment Comment: Thank You For This Payment!
Default Statement Comment: Thank You!
Default Invoice Comment: Thank You!
Customer Database Found: No
Invoice Printer Port: LPT1
Invoice Copies: 1
Automatically Print Invoice: No
Default Group: YYY
Default Type: XXX
Default Class: ZZZ
Payment Title: Donation
Invoice Title: Bill
Start Date: 03/06/90
End Date: 05/06/91
Last Invoice Number: 62342
Number of Lines Per Page: 55
DAYO Membership, TJS LAB Page: 45
■ VIEW REPORTS ON SCREEN
Use this routine to view reports directed to a disk file instead of the
printer. You can also use this routine to print a disk file report.
This routine only views files with the extension of '.TXT'.
╔══════════════════════════▌ View Reports Onscreen ▐═════════════════════════╗
║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ████░║
║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║
║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║
║ ██ ██░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║
║ ███░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║
║ ║
║ Use this option to view (and optionally print) any report written to disk. ║
║ Press Enter/Return on an empty prompt to display all files with the ║
║ extension of '.TXT'. ║
║ No limit on file size, but a large file/report takes longer to 'load'... ║
║ ║
║ Enter Report File Name to View On Screen: AGEING.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
The initial prompt requests a report file name, but you can press
Enter/Return on an empty prompt to bring up a selection window of all
reports in the current directory. Highlight the desired report, the press
Enter/Return to view it, or Alt P to print it.
╔═══════════════════════════════════════╗
║ File Name Size Date Used ║
╟──────────────┬────────────┬───────────╢
║EX1.TXT │ 10322 │ 03/15/91 ║
║M1.TXT │ 2228 │ 03/15/91 ║
║AGEING.TXT │ 26416 │ 03/15/91 ║
║NOTES.TXT │ 3618 │ 03/15/91 ║
║STMTS.TXT │ 5408 │ 03/15/91 ║
║FLABELS.TXT │ 4879 │ 03/15/91 ║
║PAYRPT.TXT │ 6243 │ 03/15/91 ║
║INVOICES.TXT │ 1619 │ 03/15/91 ║
║CONFIG.TXT │ 2389 │ 03/16/91 ║
║DAYOERR.TXT │ 540 │ 03/16/91 ║
╚══════════════╧════════════╧═══════════╝
Esc (Exit/Abort) F1 (Help) Enter/Return (View) Alt P (Print)
While viewing the report file, you can press Alt F to find a string, ie:
╔════════════════════════════════════════════════════════════════════════════╗
║ Enter Search String: JOE ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Membership, TJS LAB Page: 46
■ CONFIGURATION
This menu contains all the configuration options (settings) that
determine your organization name, address, defaults, copies and colors.
Once set, little or no requirement exists to reenter this menu.
╔════════════════════════╗ghts Reserved
║ CONFIGURATION ║ ┌────▌March 1991▐────┐
╟────────────────────────╢ │S M T W T F S │
║ Association Name ║▄███▄ ▄███▄ ██░ ██░ ▄████▄ ├────────────────────┤
║ Association Address ║█░ ██░ ██░██░ ██░ ██░ ██░ ██░│ 1 2│
║ Association Phone ║█░ ██░ ██░██░ ▀█████░ ██░ ██░│ 3 4 5 6 7 8 9│
║ Last Member Number ║█░ ██░ ███▀███░ ▀██▀ ██░ ██░│10 11 12 13 14 15 16│
║ Next Due Date ║█░ ██░ ██░ ██░ ██░ ██░ ██░│17 18 19 20 21 22 23│
║ Default Type ║▀███▀ ██░ ██░ ██░ ▀████▀ │24 25 26 27 28 29 30│
║ Default Group ║ │31 │
║ Default Class Code ║ └────────────────────┘
║ Customer Location ║════════════════════════════╗
║ Current Directory ║ Member Records: 173 ║
║ Form Letter Location ║════════════════════════════╝
║ Payment Port ║
║ Payment Copies ║
║ Auto Print Payments ║░ ██▄███░ ████░ ██▄███░ █████░ ██░ ██░ ████░ ██▄███░
║ Balance On Receipt ║░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
║ Default Pay Comment ║░ ██████░ ████░ ██████░ █████░ ██████░ ██░ ██▀███░
║ Statement Port ║░ ██░ ██░ ██░ ██░██░ █░ ██░ ██░ ██░ ██░
║ Statement Copies ║░ ██▀███░ ████░ ██░▀██░ █████░ ██░ ██░ ████░ ██░
╟────────────────────────╢
║ Select Option ║
╚════════════════════════╝
■ LIST OF CONFIGURATION OPTIONS
Association Name Statement Copies
Association Address Default Stmt Comment
Association Phone Invoice Port
Last Member Number Invoice Copies
Next Due Date Auto Print Invoice
Default Type Default Invc Comment
Default Group Labels Port
Default Class Code Auto Print Labels
Customer Location Report Printer Type
Current Directory Report Printer Port
Form Letter Location Visual Indexing
Payment Port Auto Daily Indexing
Payment Copies Payment Title
Auto Print Payments Invoice Title
Balance On Receipt Color
Default Pay Comment High Intensity
Statement Port
DAYO Membership, TJS LAB Page: 47
■ ASSOCIATION NAME
┌──────────────────────▌ ASSOCIATION or COMPANY NAME ▐───────────────────────┐
│ Enter Your Company Name: Your Organization │
└────────────────────────────────────────────────────────────────────────────┘
■ ASSOCIATION ADDRESS
┌─────────────────────▌ ASSOCIATION or COMPANY ADDRESS ▐─────────────────────┐
│ Address Line 1: Attn: Memberships │
│ Address Line 2: P.O. Box 5555 │
│ City, State ZIP: Anycity, FL 555555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
■ ASSOCIATION PHONE
┌────────────────────▌ ASSOCIATION or COMPANY TELEPHONE ▐────────────────────┐
│ Enter Your Company Telephone: 800-555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
■ LAST MEMBER NUMBER
┌───────────────────────────▌ LAST MEMBER NUMBER ▐───────────────────────────┐
│ Use this option ONLY if your membership numbers are numeric. │
│ If you do use numeric membership numbers, the MEMBER number will │
│ automatically be incremented each time you add a new member record. │
│ │
│ Enter Last MEMBER Number: 1ST-MEMBER │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 48
■ NEXT DUE DATE
Select 1 of 9 payment method codes. This payment code determines the
frequency of payments of DUES and the date of the next scheduled payment.
┌────────────────────────▌ DEFAULT DUE DATE METHOD ▐─────────────────────────┐
│ Select one of the following as your Default Due Date Method: │
│ 0 On Call... (Due Dates Not Used!) │
│ 1 Each Month at a Specified Day (15) │
│ 2 Every 2 Months at a Specified Day (1) │
│ 3 Every 3 Months (Quarterly) at a Specified Day (1) │
│ 4 Every 6 Months (Semi-annually) at a Specified Day (1) │
│ 5 Every Year (Annually) at a Specified Day (31) │
│ 6 Every 60 Number of Days │
│ 7 Every 90 Number of Days │
│ 8 Every 90 Number of Days │
│ │
│ Selected -> 5 Every Year (Annually) at a Specified Day (31) │
│ │
│ Enter Day of Month (1-31): 31 │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT TYPE
┌────────────────────────▌ DEFAULT MEMBER TYPE CODE ▐────────────────────────┐
│ The TYPE field is a user defined field used to categorize your members │
│ database (MEMBERS.DBF). Each newly added member record will default │
│ to this TYPE code. │
│ │
│ Enter Default TYPE Code: XXX │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT GROUP
┌───────────────────────▌ DEFAULT MEMBER GROUP CODE ▐────────────────────────┐
│ The GROUP field is a user defined field used to categorize your members │
│ database (MEMBERS.DBF). Each newly added member record will default │
│ to this GROUP code. │
│ │
│ Enter Default GROUP Code: YYY │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 49
■ DEFAULT CLASS CODE
┌───────────────────────▌ DEFAULT MEMBER CLASS CODE ▐────────────────────────┐
│ The CLASS field is a user defined field used to categorize your members │
│ database (MEMBERS.DBF). Each newly added member record will default │
│ to this CLASS code. │
│ │
│ Enter Default CLASS Code: ZZZ │
└────────────────────────────────────────────────────────────────────────────┘
■ CUSTOMER LOCATION
┌──────────────────▌ CUSTOMER DATABASE LOCATION/DIRECTORY ▐──────────────────┐
│ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │
│ in the same drive/directory as DAYO MEMBERSHIP. If you have installed the │
│ DAYO Customer Database (CUSTOMER.DBF), into a different directory, you │
│ need to tell DAYO MEMBERSHIP where to find it. Default is nil (current │
│ directory). Be sure to include the rightmost slash, ie: \DAYOAR\ │
│ The drive designation is optional (if same as DAYO MEMBERSHIP). │
│ │
│ Enter Location: \DAYOAR\ │
└────────────────────────────────────────────────────────────────────────────┘
■ CURRENT DIRECTORY
┌──────────────────▌ CURRENT DIRECTORY DATABASE LOCATION ▐───────────────────┐
│ This module's databases can be located in a different location other │
│ than the current directory. If you have and wish to use ALL the │
│ databases currently found in this directory from a different drive and │
│ directory, then you need to tell this module where to find them. │
│ Be sure to include the rightmost slash, ie: L:\DAYOMEM\ │
│ The drive designation is optional if same as this module. │
│ │
│ Enter Location: │
└────────────────────────────────────────────────────────────────────────────┘
■ FORM LETTER LOCATION
┌─────────────────────▌ FORM LETTER DIRECTORY/LOCATION ▐─────────────────────┐
│ This is the location of your form letters used with the Form Letters │
│ routine found in the REPORTS menu. DAYO Membership Form Letters have │
│ the extension of '.LET'. The Default location is the current directory, │
│ ie: \DAYOMEM\ │
│ Be sure to include the rightmost slash, ie: L:\DAYOMEM\ │
│ The drive designation ( ie: C: ) is optional if same as this module. │
│ │
│ Enter Location: \DAYOMEM\ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 50
■ PAYMENT PORT
┌──────────────────────────▌ PAYMENT PRINTER PORT ▐──────────────────────────┐
│ Enter Your Payment Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ PAYMENT COPIES
┌────────────────────▌ NUMBER OF PAYMENT RECEIPT COPIES ▐────────────────────┐
│ This option determines the number of Payment copies to print at the │
│ time of payment input. Default is one (1) copy. │
│ │
│ Enter Number of Payment Copies: 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ AUTO PRINT PAYMENTS
┌──────────────────▌ AUTOMATICALLY PRINT PAYMENT RECEIPT ▐───────────────────┐
│ If you want a payment receipt printed automatically after input, │
│ then change this option to Y (YES). │
│ Default is to NOT to automatically print the payment receipt. │
│ │
│ Automatically Print Payment Receipt? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ BALANCE ON RECEIPT
┌──────────────────▌ PRINT BALANCE DUE ON PAYMENT RECEIPT ▐──────────────────┐
│ If you want the Member's BALANCE to print on the payment receipt │
│ then select Y (Yes) to this option! │
│ Default is to NOT print the BALANCE. │
│ │
│ Print BALANCE on the Payment Receipt? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT PAYMENT COMMENT
┌────────────────────▌ DEFAULT PAYMENT RECEIPT COMMENT ▐─────────────────────┐
│ Enter Comment: Thank You For This Payment! │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 51
■ STATEMENT PORT
┌─────────────────────────▌ STATEMENT PRINTER PORT ▐─────────────────────────┐
│ Enter Your Statement Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ STATEMENT COPIES
┌───────────────────────▌ NUMBER OF STATEMENT COPIES ▐───────────────────────┐
│ This option determines the number of Statement copies to print. │
│ Default is one (1) copy. │
│ │
│ Enter Number of Statement Copies: 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT STATEMENT COMMENT
┌───────────────────────▌ DEFAULT STATEMENT COMMENT ▐────────────────────────┐
│ Enter Comment: Thank You For Letting Me Give You This Statement! │
└────────────────────────────────────────────────────────────────────────────┘
■ INVOICE PORT
┌──────────────────────────▌ INVOICE PRINTER PORT ▐──────────────────────────┐
│ Enter Your Payment Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ INVOICE COPIES
┌────────────────────────▌ NUMBER OF INVOICE COPIES ▐────────────────────────┐
│ This option determines the number of Invoice copies to print. │
│ Default is one (1) copy. │
│ │
│ Enter Number of Invoice Copies: 1 │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 52
■ AUTO PRINT INVOICE
┌────────────────▌ AUTOMATICALLY PRINT INVOICES AFTER INPUT ▐────────────────┐
│ If you want an printed copy of an invoice to automatically print │
│ after its input, then select Y (YES) to this option. │
│ Default is to NOT to automatically print the invoice. │
│ │
│ Automatically Print Invoice? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT INVOICE COMMENT
┌────────────────────────▌ DEFAULT INVOICE COMMENT ▐─────────────────────────┐
│ Enter Comment: Thank You For This Invoice! │
└────────────────────────────────────────────────────────────────────────────┘
■ LABELS PORT
┌──────────────────────▌ STANDARD LABELS PRINTER PORT ▐──────────────────────┐
│ Enter Your Standard Labels Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ AUTO PRINT LABELS
┌────────▌ AUTOMATICALLY PRINT STANDARD LABEL AFTER PAYMENT RECEIPT ▐────────┐
│ If you want a standard address label to be automatically printed after │
│ each payment input, then change this option to Y (YES). │
│ Default is to NOT to automatically print the label. │
│ │
│ Automatically Print Standard Address Label? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORT PRINTER TYPE
┌──────────────────────────▌ REPORT PRINTER TYPE ▐───────────────────────────┐
│ Routine reports are printed according to this selection. │
│ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │
│ The LASER printer type is a Hewlett Packard Laser compatible printer. │
│ Special Laser codes are sent to the LASER option. │
│ │
│ Enter Your Report Printer Type -> STANDARD │
│ LASER │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 53
■ REPORT PRINTER PORT
┌───────────────────▌ REPORT & FORM LETTER PRINTER PORT ▐────────────────────┐
│ Enter Your Report & Form Letter Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ VISUAL INDEXING
┌────────────────────────────▌ VISUAL INDEXING ▐─────────────────────────────┐
│ If you desire to see a progress graph each time your indexes are │
│ created, then select Y (YES). Note, the process can slow the indexing │
│ routine down; especially with larger databases. │
│ │
│ Do you wish to have Visual Indexing? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ VISUAL INDEXING
┌────────────────────────▌ AUTOMATIC DAILY INDEXING ▐────────────────────────┐
│ If this option is set to Y (YES), then all DAYO Indexes accessed by │
│ DAYO MEMBERSHIP will be recreated once daily. This will occur when the │
│ is initially run. The default is to recreate all the indexes. │
│ │
│ Recreate all DAYO MEMBERSHIP Indexes? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ PAYMENT TITLE
┌───────────────────────▌ PAYMENT ALTERNATIVE TITLE ▐────────────────────────┐
│ Instead of using the word 'Payment' on the payment receipt, you can │
│ use an alternative word (ie: Donation, Dues, ...) │
│ │
│ Enter Payment Title: Donation │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 54
■ INVOICE TITLE
┌───────────────────────▌ INVOICE ALTERNATIVE TITLE ▐────────────────────────┐
│ Instead of using the word 'Invoice' on the Invoice, you can use │
│ an alternative word (ie: Bill, Request, Notice, ...) │
│ │
│ Enter Invoice Title: Bill │
└────────────────────────────────────────────────────────────────────────────┘
■ COLOR
┌─────────────────────────────▌ COLOR MONITOR ▐──────────────────────────────┐
│ If you have a color monitor and wish to display colors, then select Y, │
│ (YES), else select N (NO) for monochrome and others. │
│ The default is color, low intensity │
│ │
│ Do you have a color monitor? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ HIGH INTENSITY
┌────────────────────────────▌ COLOR INTENSITY ▐─────────────────────────────┐
│ Intensity is only applicable with color set to Y. │
│ It will make your colors brighter... │
│ │
│ Set Color Intensity On? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 55
■ MISCELLANEOUS ROUTINES
DAYO Membership Version 1.1 TJS LAB
╔════════════════════╗l Rights Reserved
║ MISC ROUTINES ║ ┌────▌March 1991▐────┐
╟────────────────────╢ │S M T W T F S │
║ APPEND FROM ║ █▄███▄ ▄███▄ ██░ ██░ ▄████▄ ├────────────────────┤
║ BROWSE DATABASES ║ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ │ 1 2│
║ COPY (.DBF) TO ║ ██░ ██░ ██░██░ ▀█████░ ██░ ██░ │ 3 4 5 6 7 8 9│
║ CREATE DATABASE ║ ██░ ██░ ███▀███░ ▀██▀ ██░ ██░ │10 11 12 13 14 15 16│
║ DELETE RECORDS ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ │17 18 19 20 21 22 23│
║ ERASE FILE ║ █▀███▀ ██░ ██░ ██░ ▀████▀ │24 25 26 27 28 29 30│
║ EXIT TO DOS ║ │31 │
║ INDEX A DATABASE ║ └────────────────────┘
║ LIST FIELDS ║ ╔════════════════════════════╗
║ PACK DATABASE ║ ║ Member Records: 173 ║
║ MODIFY DATABASE ║ ╚════════════════════════════╝
║ RECALL RECORDS ║
║ RETURN TO MENU ║
║ RUN (DOS COMMAND) ║▄██░ ██▄███░ ████░ ██▄███░ ██████░ ██░ ██░ ████░ ██▄███░
║ SIMPLE EDITOR ║███░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
║ SORT DATABASE ║░██░ ██████░ ████░ ██████░ ██████░ ██████░ ██░ ██▀███░
║ TYPE (PRINT) FILE ║░██░ ██░ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░
║ ZAP DATABASE ║ ██░ ██▀███░ ████░ ██░▀██░ ██████░ ██░ ██░ ████░ ██░
╟────────────────────╢
║ Select Option ║
╚════════════════════╝
The MISC routines is a collection of 17 very useful Database Management
Routines. These routines provide you with the 'ability to do whatever was
left out of the rest of the program...'. These routines were modeled after
dBase (tm) III+/IV functions. Familiarity with dBase will help with the
understanding and execution of these routines.
USE WITH CAUTION!
YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES
YOU CAN ALSO MESS THINGS UP PERMANENTLY!
■ LIST OF MISC ROUTINES:
APPEND FROM PACK DATABASE
BROWSE DATABASES MODIFY DATABASE
COPY (.DBF) TO RECALL RECORDS
CREATE DATABASE RETURN TO MENU
DELETE RECORDS RUN (DOS COMMAND)
ERASE FILE SIMPLE EDITOR
EXIT TO DOS SORT DATABASE
INDEX A DATABASE TYPE (PRINT) FILE
LIST FIELDS ZAP DATABASE
DAYO Membership, TJS LAB Page: 56
■ APPEND FROM
Used to copy records from one database into another database, or to
create records from ASCII files (SDF or DELIMITED).
The Initial Screen will prompt you to enter the file name of the database
you are to append/copy the data into. At this point, you can either type in
the name of the target database, or ...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
└────────────────────────────────────────────────────────────────────────────┘
If it exists in the current directory, press enter on an empty prompt to
display all databases to select from.
┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │INVENT.DBF │ 375 │ 09/16/89 │ │
│ │AR.DBF │ 7219 │ 09/16/89 │ │
│ │HISTORY.DBF │ 103 │ 09/16/89 │ │
│ │PERSONS.DBF │ 24271 │ 09/16/89 │ │
│ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
│ │
└───────────────────────────────────────────────────────────────────────────┘
The next prompt will be to select the type of Append:
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
└──────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 57
If you are appending from another database (.DBF) then select
'Standard'.
Select the SDF option if you are appending from a 'flat' ASCII file.
Select the DELIMITED option if you are appending from a delimited ASCII
file. Delimited files contain records in which the fields are separated by
commas, and its character fields contained in double quotes...
If you select a Standard Append, you will then be prompted to enter the
name of the database you wish to get the data from. If you selected the SDF
or DELIMITED options, then enter the file name containing the data to be
appended into your target database.
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into PERSONS.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: PERSON1.TXT │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
The number of records appended into the target database will be
displayed upon completion of the task...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF From INVENTY.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: INVENTY.DBF │
│ │
│ │
│ │
│ There Were 1 Records Appended Into INVENT.DBF │
│ │
│ │
│ │
│ Press Any Key To Continue... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 58
■ BROWSE DATABASES
Used to edit/view records in a database. Enter the database name you
wish to edit/browse, or if it exists in the current directory, press enter
on an empty prompt to bring up a window box to select from.
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: INVENT.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
If there exists an index (.NDX or .NTX), with the same name as the
database, it will be utilized... The DAYO Inventory indexes are the
exception. They are automatically set/used.
An example of a browse screen:
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ MFG_PART DESC PRICE LIST │
│──────────────────╥────────────────────────────────╥────────────╥───────────│
│ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │
│ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │
│ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │
│ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │
│ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │
│ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │
│ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │
│ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │
│ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │
│ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │
│ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │
│ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │
│ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │
│ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │
│ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │
│ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │
│ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │
├──────────────────╨────────────────────────────────╨────────────╨───────────┤
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
51/60
DAYO Membership, TJS LAB Page: 59
To edit a memo field, just highlight the field, and start typing.
* * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING!
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ PRICE LIST YOURPART NOTES │
│───────────────────────╥────────────╥─────────────────╥─────────────────────│
│ 896.16 ║ 1792.32 ║ ║ <Memo> │
│ 1064.19 ║ 2128.38 ║ ║ <Memo> │
│ 672.12 ║ 1344.24 ║ ║ <Memo> │
│ 1736.31 ║ 3472.62 ║ ║ <Memo> │
│ 504.09 ║ 1008.18 ║ ║ <Memo> │
│ 784.14 ║ 1568.28 ║ ║ <Memo> │
│ 1400.25 ║ 2800.50 ║ ║ <Memo> │
┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
│You can edit memo fields too... │
│ │
│ │
│ │
│ │
│ │
│ │
└───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
Special keys for 'moving around' the BROWSE screen are:
Left Arrow Key - Move to next field to your left
Right Arrow Key - Move to next field to your right
Ctrl Home - Go to the leftmost field
Ctrl End - Go to the rightmost field (on the end of the record)
Up Arrow - Move highlight to the previous record
Down Arrow - Move highlight to the next record
PgUp - Page up a full screen of records
PgDn - Page down a full screen of records
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end or last record of the file
Ctrl N - Add a record (where applicable)
Ctrl U - Delete a record (where applicable)
F5 - To seek/find a record based upon the active index
Esc - Exit the current operation
Remember that there are many more fields to the right of the screen.
Press the right arrow key to view them...
DAYO Membership, TJS LAB Page: 60
■ COPY (.DBF) TO
Copy records to another (new) database. Use this option to copy select
records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can
also be used to create backups of data (EG: copy to floppy).
┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │HARPS.DBF │ 375 │ 09/16/89 │ │
│ │INVENT.DBF │ 7335 │ 09/16/89 │ │
│ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │
│ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │
│ │AP.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
The next prompt will be to select the type of COPY TO option you want:
┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: INVENT.DBF │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ │
│ Copy Records From INVENT.DBF │
└────────────────────────────────────────────────────────────────────────────┘
The Standard option is simply creating another database (.DBF). The SDF
and DELIMITED options will create ASCII files. The STRUCTURE option creates
a new database with the same file structure as the initial database (no
records copied).
DAYO Membership, TJS LAB Page: 61
The next prompt (optional), requires some knowledge of dBase (tm). This
prompt is requesting the user to to enter a condition or filter. If all
records are to be copied, just press Enter on an empty prompt.
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW.DBF │
│ │
│ Enter Condition: │
│ Sample condition: COST > 100 │
│ │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
This 'Condition' option is useful for coping only specific records into
a new location. Any valid dBase/Clipper statement (as shown next) is fine...
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW DBF │
│ │
│ Enter Condition: PRICE>0 │
│ Sample condition: COST > 100 │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 62
The following window message will appear while the COPY TO routine does
its task:
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW10 │
│ │
│ Enter Condition: PRICE>0 │
│ Sample cond┌───────────────────────────────────────────────┐ │
│ │┌─────────────────────────────────────────────┐│ │
│ CONDITION: ││┌───────────────────────────────────────────┐││ │
│ │││┌─────────────────────────────────────────┐│││ │
│ ││││Hold those camels while I do this COPY TO││││ │
│ │││└─────────────────────────────────────────┘│││ │
│ ││└───────────────────────────────────────────┘││ │
│ │└─────────────────────────────────────────────┘│ │
│ └───────────────────────────────────────────────┘ │
│ Copy Records From SDF To NEW10 │
└────────────────────────────────────────────────────────────────────────────┘
■ CREATE DATABASE
Create a new database. This routine lets you create entirely new
database structures. At the FIELD_NAME field, enter a unique field name. At
the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for
Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter
the size/length of the character and/or numeric field. At the FIELD_DEC
field, enter the number of decimals for the numeric field.
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ ║ ║ 0 ║ 0 │
│ ║ ║ ║ │
│ ║ ║ ║ │
┌─────────────│ ║ ║ ║ │────────────┐
│ │ ║ ║ ║ │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO Membership, TJS LAB Page: 63
* * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *
IT IS SLIGHTLY BOTHERSOME
SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to edit the new database.
This error may even cause your computer to hang!
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ NAME ║ C ║ 30 ║ 0 │
│ AGE ║ N ║ 5 ║ 1 │
│ DEAD ║ L ║ 1 ║ 0 │
│ BIRTHDATE ║ D ║ 8 ║ 0 │
┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐
│ │ ║ ║ 0 ║ 0 │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│ ║ ║ ║ │
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO Membership, TJS LAB Page: 64
■ DELETE RECORDS
Delete selected records from databases. The first prompt is for the name
of the database you wish to mark records for deletion. Like many of the
other routines, you can press enter on an empty prompt to bring up all
databases that exist in the current directory:
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│D.DBF │ 259 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/16/89 │
│XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└────────────────────────────────────────────────────────────────────────────┘
After selecting the database, all its fields will be presented atop the
screen so as to aid the user in entering a condition/filter. The use of the
condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax
is required. Note the use of the Clipper Function: EMPTY().
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
│ Enter Database Name: TRASH │
│ Delete Records For Condition: EMPTY(PART) │
│ Sample condition: COST > 100 │
│ CONDITION: EMPTY(PART) │
│ Number of Records Deleted: 208 │
│ Press any key to continue... │
└────────────────────────────────────────────────────────────────────────────┘
The number of records deleted will be displayed upon the screen as
depicted just above...
DAYO Membership, TJS LAB Page: 65
■ ERASE FILE
Erase a file (forever!). Use this option with extreme care!
Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE
PERMANENTLY REMOVED FROM EXISTENCE
NO SECOND CHANCES HERE...
The first prompt is for the file name. You can press enter on an empty
prompt to bring up a window selection of all files in the current directory.
┌────────────────────────┐
┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘
│BKDOOR.DOC │ 37029 │ 09/17/89 │
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│D.DBF │ 259 │ 09/16/89 │
│D.DBT │ 512 │ 09/16/89 │
│DAYOBK.BAK │ 36879 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
│DAYOBK.OBJ │ 35585 │ 09/16/89 │
│DAYOCAL.MAP │ 35 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│DDD.DBT │ 512 │ 09/16/89 │
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
To ERASE a file, just highlight it, then press Enter...
DAYO Membership, TJS LAB Page: 66
■ INDEX A DATABASE
You will be prompted to select the database you wish to index. After
selecting the database, by typing in the name or pressing Enter on an empty
prompt (then selecting from the window), you will be given a listing of all
fields in that database atop the screen.
┌────────[ PICK A DATABASE ]───────────┐.
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DAD.DBF │ 259 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SPW.DBF │ 7335 │ 09/16/89 │
│SOW.DBF │ 103 │ 09/16/89 │
│BOY.DBF │ 24387 │ 09/17/89 │
│SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
You will now be prompted to enter the name of the Index File. It will be
(by default), named exactly the same as the selected database, with the
exception of the extension. This will default to .NDX or .NTX depending on
whether you linked NDX.OBJ with your application.
*** Remember that the BROWSE routine only looks at indexes with the same
name as the database.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
└───────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 67
At the prompt for the index key, enter a field name, or a valid
dBase/Clipper expression.
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
│ Enter the Key Expression: PART+MFG_PART │
└───────────────────────────────────────────────────────────────┘
■ LIST FIELDS
List fields to screen or printer. This routine is a great tool for
providing simple reports and lists. The first prompt will be for the
database you wish to work with. Type the name of the file, or press Enter
on an empty prompt to bring up a window of all databases in the current
directory for selection.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│INVEND.DBF │ 259 │ 09/16/89 │
│INVENT.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SOMEDAY.DBF │ 7335 │ 09/16/89 │
│TANGO.DBF │ 103 │ 09/16/89 │
│AP.DBF │ 24387 │ 09/17/89 │
│BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 68
The next prompt is for a condition or filter. This makes it possible to
list only specific records that meet that condition you enter. The condition
must be a valid dBase/Clipper expression, or none (to list all).
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌─────────────────────────────────────────────────────┐
│ Enter Filter: │
│ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
└─────────────────────────────────────────────────────┘
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: │
│ │
└───────────────────────────────────────────────────────────────┘
A window box appears next displaying all the fields in the selected
database and an option to list all fields. Highlight any combination of
fields ( or ALL) that you want listed.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║ ├─────────────────┤ ║
╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝
│RECNO() │
│MFG_PART │
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 69
The fields you select will be displayed at center top of screen. Press
Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│DESC┌──────────────────────────────────────────────────────────────────┐
│PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │
│LIST│ │
│YOUR└──────────────────────────────────────────────────────────────────┘─┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 70
The list is very simple, and if displayed onto the screen, may look like
the following:
PART MFG_PART PRICE
4523 0.00
DAYO9S 41926 1904.34
DAYO10S 13564 616.11
DAYOCOMP 45625 2072.37
DAYOALLS 43159 1960.35
INDEXER 50558 2296.41
INDEXERS 51791 2352.42
5 DEMO 4932 224.04
DAYO13S 20963 952.17
MENUS 53024 2408.43
OFFSITEP 56724 2576.46
ONSITEP 57957 2632.47
DAYO2S 24662 1120.20
DAYO9 40693 1848.33
DAYO10 12331 560.10
DAYOCAL$ 44392 2016.36
DAYO13 19730 896.16
DAYO2 23429 1064.19
DAYO11 14797 672.12
DAYO8 38227 1736.31
DAYO1 11098 504.09
DAYO12 17264 784.14
DAYO5 30828 1400.25
......PRESS ANY KEY TO CONTINUE......
■ MODIFY DATABASE
Change the fields/structure of a database. You can add new fields,
delete fields, change the length and type of field in any of the databases.
At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field,
enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or
'M' for memofield. At the FIELD_LEN field, enter the size/length of the
character and/or numeric field. At the FIELD_DEC field, enter the number of
decimals for the numeric field.
********************************************************
*** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***
*** IT IS SLIGHTLY BOTHERSOME SORRY! ***
********************************************************
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to access the database.
This error may even cause your computer to hang!
DAYO Membership, TJS LAB Page: 71
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will 'lose' all your efforts..
■ PACK DATABASE
Pack a database (removed deleted records). This option will permanently
remove any records marked for deletion. This is another routine you should
use with great care! As in many of the other of the routines, you will be
prompted to enter the name of the database you wish to pack. Enter the name
or press Enter on an empty prompt to view the window.
┌─────┐
│PACK!│
└─────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│GOODDATA.DBF │ 259 │ 09/16/89 │
│HAP.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│LOIN.DBF │ 103 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/17/89 │
│FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
After selecting the database, you will be prompted to respond with a Yes
or No (to Pack or not to Pack...). This is the last chance you have to change
your mind...
┌──────────────────────────────────────────────────────────────────────────┐
│ PACK TOM3 │
│ Are you sure you want to PACK (remove deleted records) ? N │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 72
■ RECALL RECORDS
Recalls records previously marked for deletion. This option is identical
to the DELETE RECORDS option discussed earlier...
■ RETURN TO MENU
Returns to the Main Menu.
■ RUN (DOS COMMAND)
Run a DOS command (EG: dir/w). This option is helpful in that it allows
you to run programs at the DOS level (within memory constraints).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN CD\DOS │
└───────────────────────────────────────────────────────────────────────────┘
One useful option is to type and Enter: COMMAND at this prompt. You will
be running another DOS Shell totally out of the program (it still is in
memory though).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN COMMAND │
└───────────────────────────────────────────────────────────────────────────┘
Press and Enter: EXIT to return to your Clipper Application.
EG:
The COMPAQ Personal Computer MS-DOS
Version 3.31
(C) Copyright Compaq Computer Corp. 1982, 1987
(C) Copyright Microsoft Corp. 1981, 1987
C:\KISBBS>EXIT
DAYO Membership, TJS LAB Page: 73
■ SIMPLE EDITOR
A simple editor and word processor. Use this option to create and read
simple TEXT files. File size is limited to your machines capabilities or
32,000k. The first prompt is for the name of the file you wish to edit. Type
in the name, or press Enter on an empty prompt to bring up a window option
box containing all files in the current directory.
┌────────────────────────┐
┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐
│ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │
│ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │
└────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
│DEMO.MAP │ 7780 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
*** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...),
so be careful at what you select for viewing/editing.
If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE
those changes. If you exit with an Esc, all changes will be lost!
┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
│CLIPPER demo │
│CLIPPER MISC │
│KWAIT 10 │
│LIB MISC-+MISC,MISC.LST,MISC │
│KWAIT 10 │
│TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │
│KWAIT 10 │
│DEMO │
└────────────────────────────────────────────────────────────────────────────┘
Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0
DAYO Membership, TJS LAB Page: 74
Special keys for 'moving around' the SIMPLE EDITOR screen are:
Left Arrow Key - Move to your left
Right Arrow Key - Move to your right
Ctrl Home - Go to the top, leftmost corner of window
Ctrl End - Go to the bottom, rightmost corner of window
Up Arrow - Move up one line
Down Arrow - Move down one line
PgUp - Page up a full screen
PgDn - Page down a full screen
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end of the file
* F2 - Import text from a text file
* Ctrl W - Save Changes and Exit
* Esc - ABORT Changes and Exit
The margin may exceed the boundaries on the right side of the screen,
but the text is easily accessed using the special keys above...
■ SORT DATABASE
This option takes a database, sorts it, and copies the result into a new
database. The first prompt is for the name of the database you want to sort.
Enter the name, or press Enter on an empty prompt to bring up a window box
containing all databases in the current directory.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DOG.DBF │ 259 │ 09/16/89 │
│CAT.DBF │ 375 │ 09/16/89 │
│CAR.DBF │ 195 │ 09/17/89 │
│BAM.DBF │ 7335 │ 09/16/89 │
│HARP.DBF │ 103 │ 09/17/89 │
│TRAIN.DBF │ 24387 │ 09/17/89 │
│HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└───────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 75
The next prompt is for the name of the database you will be creating
with the sorted data.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: INVNET.DBF │
│ Enter Name of Sorted File: INVNET1.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
The next prompt is for the sort field (limited to 1 field)...
╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: TOM.DBF │
│ Enter Name of Sorted File: TOM1.DBF │
│ Enter the Key Expression: PART │
└───────────────────────────────────────────────────────────────┘
■ TYPE (PRINT) FILE
Prints an ASCII/text file to screen or printer. The first prompt is for
the file name.
┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
│ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │
│ Press Enter/Return on an empty field to get a current directory listing. │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 76
The display of the file (any type), is continuous, but can be paused by
any key (except the Enter & Esc keys). Pressing the Enter key will slow the
printing of the file onto the screen. Press Esc to Abort the display... A
sample display:
FUNCKEY...........MISC FUNIQUE...........MISC
FZAP..............MISC GET_PIC1..........MISC
ISDATA............MISC ISDBF.............MISC
MENU_KEY..........MISC MISC..............MISC
OKFILE............MISC PACKIT............MISC
PICKDBF...........MISC PROCLIST..........MISC
SHOW_INS2.........MISC STATLINE2.........MISC
TOG_INS2..........MISC XKEY_CLEAR........MISC
XKEY_NORM.........MISC XMEMO.............MISC
MISC
BKDOOR BROWSEIT CENTER1 COLORSET
DBFUNCT DBFUNCT6 EDITOR FACHOICE
FAPPEND FCOPY2 FDBF1 FDELETE
FERASE FILESZ FILE_UDF FILT
FINDER FINDEX FMAKEDB FMODYDB
FNEW FRECALL FRUN FSCROLL1
FSORT FTYPEIT FUNCKEY FUNIQUE
FZAP GET_PIC1 ISDATA ISDBF
MENU_KEY MISC OKFILE PACKIT
PICKDBF PROCLIST SHOW_INS2 STATLINE2
TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO
PRESS ANY KEY TO CONTINUE...
■ ZAP DATABASE
Totally erase all records in database (forever!). When you want to
remove every record from a database, then use this option. Use with EXTREME
CAUTION! The first prompt is for the file name. Enter the name of the
database you are to 'clean out', or press Enter to select the database from
a window containing all databases in the current directory.
DAYO Membership, TJS LAB Page: 77
┌────┐
│ZAP!│
└────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DENVER.DBF │ 259 │ 09/16/89 │
│OHIO.DBF │ 375 │ 09/16/89 │
│NEWYORK.DBF │ 195 │ 09/17/89 │
│MONTANA.DBF │ 7335 │ 09/16/89 │
│SC.DBF │ 259 │ 09/17/89 │
│EARS.DBF │ 103 │ 09/17/89 │
│FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐
│MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │
│CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │
└──────────────┴────────────┴──────────┘───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
You will be prompted one last time as to whether you still want to ZAP
the selected database. Press Y for Yes, N for No...
┌────┐
│ZAP!│
└────┘
┌──────────────────────────────────────────────────────────────────────────┐
│ ZAP TRASH │
│ Are you sure you want to ZAP (remove all records permanently) ? N │
│ │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 78
■ HELP SCREENS
While in the browse screens, some of the option windows, and in the
SIMPLE EDITOR, pressing the F1 key, will display a help screen.
BROWSE help:
┌──────────────────────[ DAYOMEM HELP: DBEDIT, 0, ]─────────────────────────┐
│ │
│- Special keys for 'moving around' the BROWSE screen are: │
│ │
│ Left Arrow Key - Move to next field to your left │
│ Right Arrow Key - Move to next field to your right │
│ Ctrl Home - Go to the leftmost field │
│ Ctrl End - Go to the rightmost field (on the end of the record)│
│ Up Arrow - Move highlight to the previous record │
│ Down Arrow - Move highlight to the next record │
│ PgUp - Page up a full screen of records │
│ PgDn - Page down a full screen of records │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end or last record of the file │
│ Ctrl N - Add a record (where applicable) │
│ Ctrl U - Delete a record (where applicable) │
│ F5,F6,F7 - To seek/find a record based upon the active index │
│ Esc - Exit the current operation │
│ │
│ Remember that there are many more fields to the right of the screen. │
│ Press the right arrow key to view them... │
└────────────────────────────────────────────────────────────────────────────┘
Option Box Help:
┌───────────────────────[ DAYOMEM HELP: ACHOICE, 0, ]───────────────────────┐
│ │
│ │
│ │
│ │
│ - Special keys for 'moving around' the Option Box are: │
│ │
│ Up Arrow - Move up one option │
│ Down Arrow - Move down one option │
│ PgUp - Page up multiple records │
│ PgDn - Page down multiple records │
│ Esc - ABORT and Exit │
│ │
│ │
│ After highlighting the option you desire, press Enter... │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Membership, TJS LAB Page: 79
Editor help:
┌──────────────────────[ DAYOMEM HELP: MEMOEDIT, 0, ]───────────────────────┐
│ │
│ - Special keys for 'moving around' the EDITOR screen are: │
│ │
│ Left Arrow Key - Move to your left │
│ Right Arrow Key - Move to your right │
│ Ctrl Home - Go to the top, leftmost corner of window │
│ Ctrl End - Go to the bottom, rightmost corner of window │
│ Up Arrow - Move up one line │
│ Down Arrow - Move down one line │
│ PgUp - Page up a full screen │
│ PgDn - Page down a full screen │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end of the file │
│ Ctrl W - SAVE Changes and Exit │
│ Esc - ABORT Changes and Exit │
│ F2 - Import another text file into your document │
│ │
│ The margin may exceed the boundaries on the right side of the screen, │
│ but the text is easily accessed using the special keys above... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
■ EXPANDED HELP
After Version 1.3, expanded help routines were added to all DAYO modules.
At almost all prompts and menus you can press F1 for help. Help can be a
function key message as displayed on previous page, a message that you have
created (user defined & inputted), or the ability to read the documentation
on the screen (saves paper).
DAYO Membership, TJS LAB Page: 80
■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
If you press F1 and no user defined & inputted message exists for that
section of the program you are currently in you will receive a message to
this effect, and then a blank/empty screen.
The editing keys for this option are the same as for the Simple Editor
(previous page).
┌──────[ DAYO HELP Called by Program: DAYOMEM Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ │
│ │
│ ╔════════════════════════════════════════════════════════╗ │
│ ║ No Online Help Messages Exist for this prompt... ║ │
│ ║ ║ │
│ ║ You can type in any help message you wish, or ║ │
│ ║ press F1 to view the document for DAYOMEM. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ Press any key to continue... ║ │
│ ╚════════════════════════════════════════════════════════╝ │
│ │
│ │
├───────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │
└───────────────────────────────────────────────────────────────────────────┘
If you wish to input anything at this point, just type whatever you
wish, remembering to press Ctrl W to save all changes. Pressing Esc will
not save ANY changes ( all effort you put into writing a help message will
be lost! ).
DAYO Membership, TJS LAB Page: 81
┌───────[ DAYO HELP Called by Program: DAYOMEM Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ Type in anything you wish about this portion of the program! │
│ │
│ The length of this file can be many pages... │
│ │
│ Be sure to press Ctrl W to save any changes/additions you make to this │
│ screen. │
│ │
│ │
│ │
│ │
│ │
│ │
├────────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
└────────────────────────────────────────────────────────────────────────────┘
■ VIEW DOCUMENTATION ONSCREEN
To view the documentation for the module you are in, it must first exist
in the current directory. Document files are named the same as the module,
and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOMEM.DOC, DAYOPAY.DOC.
Press F1 in the User Defined & Inputted Help Message screen to display the
document (user manual). The special keys in this option are displayed in the
Help Screen (press F1 again) for this option:
╔══════════════════════════════════════════════════════════════════════════╗
║ While viewing the document for DAYOPAY the keyboard is configured ║
║ as followed: ║
║ ║
║ Esc Exit ║
║ F5 Find a string. This search is not case sensitive ║
║ Examples: PAGE 50 ║
║ INTRODUCTION ║
║ REPORTS ║
║ Home Return to the beginning of the document ║
║ End Go to the bottom of the document ║
║ PgUp Page up ║
║ ║
║ Any other key moves acts like PgDn (page down) ║
║ ║
║ Press any key to continue... ║
╚══════════════════════════════════════════════════════════════════════════╝
DAYO Membership, TJS LAB Page: 82
■ DATABASE STRUCTURE
Database: MEMBERS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 MEMBER Character 12 1 12
2 NAME Character 30 13 42
3 FIRSTNAME Character 15 43 57
4 ADDRESS1 Character 30 58 87
5 ADDRESS2 Character 30 88 117
6 CITY Character 22 118 139
7 STATE Character 2 140 141
8 ZIP Character 10 142 151
9 PHONE1 Character 14 152 165
10 PHONE2 Character 14 166 179
11 DATE Date 8 180 187
12 LASTDATE Date 8 188 195
13 NEXTDATE Date 8 196 203
14 BALANCE Numeric 10 2 204 213
15 DUES Numeric 10 2 214 223
16 PAYHIST Numeric 10 2 224 233
17 GROUP Character 8 234 241
18 TYPE Character 8 242 249
19 CLASS Character 8 250 257
20 FAX Character 14 258 271
21 CUSTOMER Numeric 6 272 277
22 COMMENT Character 50 278 327
23 PMETHOD Numeric 1 328 328
24 ACTIVE Logical 1 329 329
─────
Total 330
Database: MEMBMEMO.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 MEMBER Character 12 1 12
2 NOTES Memo 10 13 22
─────
Total 23
DAYO Membership, TJS LAB Page: 83
Database: MINVOICE.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 INVOICE Numeric 8 1 8
2 MEMBER Character 12 9 20
3 AMOUNT Numeric 10 2 21 30
4 DESC Character 30 31 60
5 DATE Date 8 61 68
6 TYPE Character 8 69 76
7 CLASS Character 8 77 84
8 GROUP Character 8 85 92
─────
Total 93
Database: PAYMENTS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 PAYMENT Numeric 6 1 6
2 MEMBER Character 12 7 18
3 AMOUNT Numeric 10 2 19 28
4 DATE Date 8 29 36
5 TYPE Character 8 37 44
6 CLASS Character 8 45 52
7 GROUP Character 12 53 64
8 CHECK Character 30 65 94
─────
Total 95
DAYO Membership, TJS LAB Page: 84
■ DATA DICTIONARY
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ────────────────────────────────────
ACTIVE L 1 0 MEMBERS.DBF Flag that denotes a member as being
actively 'envolved' with the
organization
ADDRESS1 C 30 0 MEMBERS.DBF Member address line 1
ADDRESS2 C 30 0 MEMBERS.DBF Member address line 2
AMOUNT N 10 2 MINVOICE.DBF Invoice/Donation amount
PAYMENTS.DBF Payment/Dues amount (received)
BALANCE N 10 2 MEMBERS.DBF Dues balance
CHECK C 30 0 PAYMENTS.DBF Check number of payment and/or
description of payment
CITY C 22 0 MEMBERS.DBF
CLASS C 8 0 MINVOICE.DBF Class code for Invoices
PAYMENTS.DBF Class code for Payments
MEMBERS.DBF Class code for Members and the
default Class code for the
member's payments and invoices
COMMENT C 50 0 MEMBERS.DBF Comment about a member
CUSTOMER N 6 0 MEMBERS.DBF Customer number (not required)
DATE D 8 0 MINVOICE.DBF Date invoice record was created
MEMBERS.DBF Date member record was added
PAYMENTS.DBF Date payment was made
DESC C 30 0 MINVOICE.DBF Description of the invoice
DUES N 10 2 MEMBERS.DBF Amount due per period
FAX C 14 0 MEMBERS.DBF Fax telephone number of member
FIRSTNAME C 15 0 MEMBERS.DBF Firstname of member (not required)
GROUP C 8 0 MINVOICE.DBF Group code, user determined
MEMBERS.DBF
PAYMENTS.DBF
INVOICE N 8 0 MINVOICE.DBF Invoice number
LASTDATE D 8 0 MEMBERS.DBF Last date payment made
MEMBER C 12 0 MEMBERS.DBF Member number
MINVOICE.DBF
MEMBMEMO.DBF
PAYMENTS.DBF
NAME C 30 0 MEMBERS.DBF Name of member
NEXTDATE D 8 0 MEMBERS.DBF Next date payment will be due
NOTES M 10 0 MEMBMEMO.DBF Member notes/comments, up to 16,000
bytes (about 18 pages)
PAYHIST N 10 2 MEMBERS.DBF Total amount of payment receipts
PAYMENT N 6 0 PAYMENTS.DBF Payment number
PHONE1 C 14 0 MEMBERS.DBF Member telephone #1
PHONE2 C 14 0 MEMBERS.DBF Member telephone #2
PMETHOD N 1 0 MEMBERS.DBF Payment Method (0-8)
STATE C 2 0 MEMBERS.DBF
TYPE C 8 0 PAYMENTS.DBF Member type, user determined
MEMBERS.DBF
MINVOICE.DBF
ZIP C 10 0 MEMBERS.DBF Zipcode
DAYO Membership, TJS LAB Page: 85
■ DAYO POS MAINTENANCE & QUIRKS
After a period of time, the number of deleted records will increase to
the point of becoming a problem and delays. Use the PACK option in the MISC
routines to permanently remove the deleted records.
On occasion (maybe an under statement), index files will get corrupted,
especially on networks. To 'fix' a corrupted index requires that everyone
'get out of' the DAYO databases, and then perform a reindexing (actually a
recreation of the indexes). The reindex is accomplished by running the DAYO
Membership program with a parameter of 'INDEX' (or using DAYOX).
ie:
C:\>DAYOMEM INDEX
If you are on a Novell (tm) multiuser network, you must 'flag' (change
file attributes) of all files to make them sharable, readable and writable.
This is VERY important, especially just after an index!
ie:
E:\>FLAG *.NTX SRW
or just to be safe, go ahead and flag all files in the DAYO directory:
E:\>FLAG *.* SRW
Indexes are recreated once every day. This is automatically performed by
the first user to run DAYO Membership. This process will take more time as
your files get larger. This process should take place daily, but you can run
it at night with a batch file that waits until after midnight (ie: DAYO
Clock), or a with many scheduling programs (ie: our BRAIN). All other users
and computers must NOT be using any of the databases, or the procedure will
'crash'. Remember to 'flag' the indexes sharable, readable and writable
every time you create/reindex them.
Backups of your data and configuration files should take place daily!
You have no doubt heard many scare stories. They are all true! The key
files that need to be backed up all have the extension of .DBF, and .CFG.
The .DBF files are your databases. The .CFG file(s) contain your
configuration information (as seen in the Configuration menu).
DAYO Membership, TJS LAB Page: 86
If you must use dBase (tm) with DAYO Membership, and you are on a PC
based network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY
databases. This will allow the opened database to be shared, and more
importantly, prevent a user (or all users!) from 'crashing'!
If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files,
then do not use it... Hope to fix this 'feature' with the next upgrade...
If you require an additional decimal for your taxrate (ie: 0.0625), then
you will have to modify the TAXRATE field in the databases TAXCODES.DBF,
INVOICE.DBF, QUOTES.DBF, CUSTOMER.DBF, ARH.DBF. Use the MODIFY DATABASE
option in the MISC ROUTINES to change the length from 5 to 6, and the
number of decimals from 3 to 4.
┌───────[ MODIFY STRUCTURE: TAXCODE.DBF ]─────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│════════════╦════════════╦═══════════╦═══════════│
│ TAXCODE ║ C ║ 1 ║ 0 │
│ TAXRATE ║ N ║ 6 ║ 4 │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│════════════╩════════════╩═══════════╩═══════════│
│ Press Enter to edit any field... │
└───────[PRESS Ctrl W TO SAVE AND EXIT]─────────┘
DAYO Membership, TJS LAB Page: 87
■ TJS 'Computer' LAB
TJS LAB is an association of programmers and technicians that produce
customized, multiuser software for the PC based network (ie: Novell and
others). Our specialties include Inventory Control, PC Communications/EDI,
Management, Reports (standard and graphic), Data Conversions, and
Accounting (A/R, A/P).
A unique feature of TJS LAB is that our software is by default,
multiuser. 'Standalone' applications are the exception! All our applications
are written in Clipper, Basic, or C (preferably Basic or Clipper). We will
license all our application source codes. We produce applications that work,
are easy to use, and are inexpensive!
Want a change?
Want an enhancement!
Want a completely new product/application?
Want to make your idea a reality?
Custom/contract programming, by TJS LAB, and our associates is available.
Standard rate is $35.00 per hour (our sites). Guaranteed quality and timely
work is our number one policy.
We make program enhancements/changes/fixes at our location(s), but can/do
make 'house calls' via special software and a modem.
Write us at:
TJS LAB
PO Box 585366
Orlando, Florida 32858-5366
Or call us (8:00 am - 11:00 pm):
(407) 291-3960
* Note that TJS LAB, nor any of the associates accept/take any support
calls for unregistered Shareware products.
TJS LAB, Computer Division
In an effort to provide the 'total solution', TJS LAB now offers personal
computer systems, printers, software and accessories at a much discounted
price. All equipment is warranted by the manufacturer for at least one year.
Call or write us for more information...
